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.