If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Total in report header for calculated field
I have a control on my report that calculates the cost, depending on whether
the user has typed in their own value so [CCost] = =IIf([Cost]=0,[cost],[quantity]*[itemcost]). I have put in a hidden textbox [CCostText] and I can use this to give me totals at the end of each section and at the end of the whole report (using over group and over all) - which is great. However I really want the overall total at the top of the report - and I cannot persuade it to do this - but it would if it was simply the [cost] that I was totalling. Any ideas? |
#2
|
|||
|
|||
Total in report header for calculated field
Try sum the expression for anywhere you need it such as group or report
headers or footers. =Sum(IIf([Cost]=0,[cost],[quantity]*[itemcost])) -- Duane Hookom MS Access MVP -- "HelenJ" wrote in message ... I have a control on my report that calculates the cost, depending on whether the user has typed in their own value so [CCost] = =IIf([Cost]=0,[cost],[quantity]*[itemcost]). I have put in a hidden textbox [CCostText] and I can use this to give me totals at the end of each section and at the end of the whole report (using over group and over all) - which is great. However I really want the overall total at the top of the report - and I cannot persuade it to do this - but it would if it was simply the [cost] that I was totalling. Any ideas? |
#3
|
|||
|
|||
Total in report header for calculated field
Thanks Duane - works a treat
"Duane Hookom" wrote: Try sum the expression for anywhere you need it such as group or report headers or footers. =Sum(IIf([Cost]=0,[cost],[quantity]*[itemcost])) -- Duane Hookom MS Access MVP -- "HelenJ" wrote in message ... I have a control on my report that calculates the cost, depending on whether the user has typed in their own value so [CCost] = =IIf([Cost]=0,[cost],[quantity]*[itemcost]). I have put in a hidden textbox [CCostText] and I can use this to give me totals at the end of each section and at the end of the whole report (using over group and over all) - which is great. However I really want the overall total at the top of the report - and I cannot persuade it to do this - but it would if it was simply the [cost] that I was totalling. Any ideas? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
sorting data in a report | David | Setting Up & Running Reports | 21 | October 14th, 2005 03:05 PM |
Total hours from Table into Report | HeatherLou1974 | General Discussion | 3 | March 7th, 2005 08:04 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |