View Full Version : Totals with a query?


eggs3
07-31-2001, 04:10 AM
Can I design a query that will give me totals in certain fields after the query is run?

Rich
07-31-2001, 07:21 AM
You can create a totals query is that what you want?

eggs3
07-31-2001, 09:46 AM
I have a query which gathers the cost/day of certain personnel at certain locations depending upon the parameters you set.

What I would like to know is if I can put something in the query that would then total the column cost/day.

Thanks for any help you can give.

Rich
07-31-2001, 11:47 AM
Why not put the total on a form or in a report?

eggs3
07-31-2001, 11:55 AM
I'd be willing to put it on a report. I've already got one set up for the query. Can you tell me how to put a sum in the report? Bear with me...as you can tell, I'm just learning the basics. I really appreciate your help!

Rich
07-31-2001, 12:16 PM
Just add a text box set the control source to =Sum([YourField]) anywhere but the page footer.
HTH