totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a query that has a total field, how do I create a grandtotal. I.E.
all records have a balance and i need a total of all ballance owed.

Hope I was clear enough & thanks

Coconutt
 
Hi, I have a query that has a total field, how do I create a grandtotal. I.E.
all records have a balance and i need a total of all ballance owed.

Hope I was clear enough & thanks
Click to expand...

You cannot (at least not in any reasonably easy way) in a Query.

Usually you would do this on a Form or a Report. You can put a textbox
on a Form or Report footer (not on a Page Footer though) with a
control source

=Sum([Subtotal])

to sum up all the displayed values in the field named Subtotal.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
FOLLOW-UP QUESTION. IS IT POSSIBLE TO HAVE A PAGE TOTAL AS WELL AS A GRAND
TOTAL?

John Vinson said:
Hi, I have a query that has a total field, how do I create a grandtotal. I.E.
all records have a balance and i need a total of all ballance owed.

Hope I was clear enough & thanks
Click to expand...

You cannot (at least not in any reasonably easy way) in a Query.

Usually you would do this on a Form or a Report. You can put a textbox
on a Form or Report footer (not on a Page Footer though) with a
control source

=Sum([Subtotal])

to sum up all the displayed values in the field named Subtotal.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
Back
Top