asked on

continuous forms (Access) grand total

Hi there,

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.

ASKER CERTIFIED SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

herbacious

ASKER

Thanks Pete

I got the first part working - totalling up each column at the bottom

So, I have at the bottom in the footer a total for each column - but when I try and total up these totals - it brings an error display in the text box - and then all of the above totals that were working fine up to that point!!!

I think it could be the exact syntax of what I am putting in.

Whats the easiest way of putting this expression into the box? Is the code builder the best?

What syntax do I need to enter in the grand total box?

I tried =Sum([price1total]+[price2total]+[deliverypricetotal]) - but this brought the above error.

Any clues?

herbacious

ASKER

Pete,

SORTED!!!!!

God knows what I was doing - But I just had a coffee and a fag - came back to it - tried it again and its working (like a dream).

Thanks mate!

herbacious

ASKER

oh - by the way - fag means "cigarette" in the UK.

If your not from the UK.