Creating grand totals in a query and using count aggregate function

K

KDes

Hello,
I am taking a class on Access 2003 and I am having trouble with a query. My
query consists of a group of orders. I am supposed to calculate the grand
total number of orders and grand totals for the total invoice, amt paid, and
amt owed(which is a calculated field). I was told I need to use the count
function to calculate the number of orders. Can anyone help?
Thanks,
KDes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grand Total in a Query 2
Using Sum and Count function 1
Creating a Chart on form from selected data in query. 0
Using count in a query 4
monthly totals 0
Aggregate calculations on calculated query fields? 8
Assistance need to populate "GRAND TOTAl" "MSpivottable11" in Microsoft web component 0
Creating a totals per row in query 8

Top