total or total

[w9707384]

i have a report which calculates the total of all the customer orders made by an employee. I have done this by

calculating the line total of each order - done
calculating the order total of each order - done
but i am having trouble when calculating the total of all the orders please help

 

[Axis]

Access is smart about calculations in report. A field with the expression =Sum[CustomerOrders] as the record source (assuming CustomerOrders is the name of your field) will give you the total for all customer orders, and you can place it according to what total you want. If you put it in the Report footer, you'll get the total for everything in the report; in the Page Foot for just that page, in the Group footer for the group, etc., etc.

 

[w9707384]

i tries what u are saying but i'm afraid it doesn't work, i tried that before as well

at present i have
[customer order.customer order id] footer whcih holds the result of the total for each order. this works fine.
i have tried placing it in all the footers. but two of the footes results with £0.00
and the report footer results in #Error , i don't know what is wrong, please help

 

[Axis]

1. Check the name of the text box that you want to sum. Errors most often occur when you refer to something using the wrong name. You must refer specifically to the text box by name in order to tell Access what yuo want totaled.
2. Use the Sum function to total all of the amounts in this field, making sure that you have the correct field name. In the footer create a new text box, and in the record source for that box put =Sum[Name of your field].

[This message has been edited by Axis (edited 04-29-2000).]

[This message has been edited by Axis (edited 04-29-2000).]

 

[w9707384]

thanks for that, I tried it but it didn't work, me report works like this

I choose an employee .......
I then display all the customer orders done by that employee.
Each customer order is made up of customer order lines ....... the line total for each line is used to calculate the order total, this works, but problem is counting the total of all the orders.....

 

[Deb in LA]

Can you put a new column in your query and have a sum of the total orders in the query? Then put that field in the appropriate footer sections?

Deb

 

[Deb in LA]

Sorry - wasnt done...
Then for example the new column is SumOrders: sum(orders)in your query,
Then in your report, SumOrders is in the group footers for each order. Then in the report footer, sum(SumOrders).

Deb

 

[w9707384]

AT Last. the problem was that the field was in the wrong footer. the footer that the field was in didn't have a header from which it was able to get the info, i have since then corrected it by

placing a copy of the customer order line fields in the main header and from their using the sum total to calculate the total of all the sales.

thanks for all the help