I have a telephone order database which I need to compile monthly stats from.
I have created a query which asks for a date range which it then displays in a continuous form.
Now - I need it to give me a grand total for the whole range - but all I can get is a total for that LINE in the totals box I created in the form footer.
How can I get it to do a grand total for the entire range? On each line there is 4 x fields for product price and then a delivery price box. Each line needs to be totalled and then the entire rangethat is displayed.
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!