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.  
Who is Participating?
peter57rConnect With a Mentor Commented:
Hello herbacious,

In the form footer add a texbox and type the formula into it:

Do this for each field you want to sum.

To total an individual line in the delivery price box type a formula:
= field1 + field 2 + field3 + field4
using your own field names, of course.

If you want a grand total of this you need another box in the form footer with the formula:

=Sum(field1 + field 2 + field3 + field4)

herbaciousAuthor Commented:
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?  
herbaciousAuthor Commented:


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!
herbaciousAuthor Commented:
oh - by the way - fag means "cigarette" in the UK.  

If your not from the UK.  
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.