cozmo_troll
asked on
Report totaling sales
Hello,
I have a fairly complex database for keeping track of orders from customers. I need a report that will show totals for sales or each inventory item. How can this be setup? Further to that I will want to have it pull only sales from specific show events and dates, etc. but think I can manage that once the initial report is setup. It seems like it should be easy, but I can't figure it out.
Thanks,
I have a fairly complex database for keeping track of orders from customers. I need a report that will show totals for sales or each inventory item. How can this be setup? Further to that I will want to have it pull only sales from specific show events and dates, etc. but think I can manage that once the initial report is setup. It seems like it should be easy, but I can't figure it out.
Thanks,
Use Grouping and include a group footer. In that footer, insert a text box with a control source of something like =Sum([ShowSales]) where ShowSales is the field you want to total.
Create a Report from the Orders Table (or whatever table lists the sales of all of the individual items)
For the "Grouping Options", select the Items field.
For the "summary options", select "Sum" for the ItemPrice Field
The other part of your question: "pull only sales from specific show events and dates"
Will require a different set of logic and should really be addressed in a separate, new question, to avoid confusion as to what the answer is to "This" question.
For the "Grouping Options", select the Items field.
For the "summary options", select "Sum" for the ItemPrice Field
The other part of your question: "pull only sales from specific show events and dates"
Will require a different set of logic and should really be addressed in a separate, new question, to avoid confusion as to what the answer is to "This" question.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
;-)