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
|
|||
|
|||
Totals in Report Footer
I have a report that pulls from an orders detail table. One line per product.
I am printing the Group footer for each order only and summing the Qty, Sell Price, Cost, Etc. I am also pulling the invoice total sales tax from an invoice table (not details). This part all works great. on each line I have: Total Items =Sum([Qty]) Total Retail =Sum([RetialPrice]) etc. I also have.. Total Tax =[OrderSummary].[TotalTax] Invoice totla =[TotalRetail]+[Total Tax] Each line looks finr. In my report footer, I used "Sum" to get the total number of items on the report, the total retail, total cost, etc. No matter what I do, I can't total the Tax or the Invoice Amount. If I run it so only one invoice shows up, and it has tax of $1.00 and total items sold of 3, My tax total ends up being $3.00. This is because my query is based off a detail table (one record per item) and that is linked to the Summary Order table where the amount of tax for the whole invoice lives. Can anyone tell me how to get the report total tax and report total invoice amounts? Thanks!!!! --- Rick B |
#2
|
|||
|
|||
Totals in Report Footer
If your tax is based on the summary table, then you can't use Sum() since it
will be multiplied by the number of details. You can reference the value without using Sum() in the invoice header or footer. If you have multiple invoices (each having their own tax amount), you can use a running sum on a text box in the invoice header or footer. If the name of the running sum tax text box is "txtRunSumTax", you can place a text box in the report footer with a control source: =txtRunSumTax -- Duane Hookom MS Access MVP -- "Rick B" wrote in message ... I have a report that pulls from an orders detail table. One line per product. I am printing the Group footer for each order only and summing the Qty, Sell Price, Cost, Etc. I am also pulling the invoice total sales tax from an invoice table (not details). This part all works great. on each line I have: Total Items =Sum([Qty]) Total Retail =Sum([RetialPrice]) etc. I also have.. Total Tax =[OrderSummary].[TotalTax] Invoice totla =[TotalRetail]+[Total Tax] Each line looks finr. In my report footer, I used "Sum" to get the total number of items on the report, the total retail, total cost, etc. No matter what I do, I can't total the Tax or the Invoice Amount. If I run it so only one invoice shows up, and it has tax of $1.00 and total items sold of 3, My tax total ends up being $3.00. This is because my query is based off a detail table (one record per item) and that is linked to the Summary Order table where the amount of tax for the whole invoice lives. Can anyone tell me how to get the report total tax and report total invoice amounts? Thanks!!!! --- Rick B |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
name footer totals in report footer | rong | Setting Up & Running Reports | 4 | January 9th, 2006 03:45 PM |
Report Footer and Grand Totals on one page | John Foster | Setting Up & Running Reports | 5 | December 21st, 2005 05:03 PM |
Print page footer only when needed | Carl Rapson | Setting Up & Running Reports | 9 | November 14th, 2005 07:57 PM |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
To Sharkbyte and all: Calculate a total values in group level | Ally | General Discussion | 6 | June 13th, 2005 08:16 PM |