Can I design a query that will give me totals in certain fields after the query is run?
E eggs3 New member Local time Today, 06:12 Joined Jul 31, 2001 Messages 8 Jul 31, 2001 #1 Can I design a query that will give me totals in certain fields after the query is run?
E eggs3 New member Local time Today, 06:12 Joined Jul 31, 2001 Messages 8 Jul 31, 2001 #3 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.
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.
E eggs3 New member Local time Today, 06:12 Joined Jul 31, 2001 Messages 8 Jul 31, 2001 #5 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!
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!
R Rich Guest Jul 31, 2001 #6 Just add a text box set the control source to =Sum([YourField]) anywhere but the page footer. HTH