Totals of all Orders Per Customer
I have a Access 2010 DB that was built out of the NW traders example. This DB is setup to sell items to crew on one of our large boats, 200+ crew.
We have "Trip Reports", each trip is closed when they dock and unload fish. Then accounting uses these reports for payroll deductions.
Right now it gives a total per order, per customer. So if one person buys from the store, three different times, he will have three different orders, and three different totals on the report.
I can put a Grand Total in the report footer and if only one customer is selected it will give the grand total for that, becuase its only for one person and the report is over. If it runs for eveyone, the grand total ends up being the total for every order from every customer, which is good to have as well.
I really need to get it to show the total of all orders per person as well.
I will attach a couple of screen shots or the report in design and report view.
Thank you.
Trip-Report-Design-View.JPG
Report1.JPG
report-pg-2.JPG
We have "Trip Reports", each trip is closed when they dock and unload fish. Then accounting uses these reports for payroll deductions.
Right now it gives a total per order, per customer. So if one person buys from the store, three different times, he will have three different orders, and three different totals on the report.
I can put a Grand Total in the report footer and if only one customer is selected it will give the grand total for that, becuase its only for one person and the report is over. If it runs for eveyone, the grand total ends up being the total for every order from every customer, which is good to have as well.
I really need to get it to show the total of all orders per person as well.
I will attach a couple of screen shots or the report in design and report view.
Thank you.
Trip-Report-Design-View.JPG
Report1.JPG
report-pg-2.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It is a bit more complicated than that
(especially if you are using the "OrderDetails" table...
Create a query with all the needed fields from all the tables (3)
(I would still add in a new "Totals" field to this query.)
...Then use the Report wizard.
Make sure for the "How do you want to view you data" section, ... that it is in this order:
Customer, Order, Ordedetails
In the next screen, For grouping, do not change anything
For Summary Options, select "sum" for the Totals Field.
You will, most likely, have to "Massage" the report design quite a bit until it looks just right...
Here is a quick and dirty sample I created...
You will have to study it carefully and try to adapt it to work in your DB
(That is, ...if this is even what you wanted... ;-) )
;-)
JeffCoachman
Database59.accdb