Can I add up the total of a column in a query

J

jojo

I am trying to add up a column of numbers in a query. Is this possible? I
went through help but don't understand what they are saying. I really need
an answer that an Acdess Dummy can understand.
 
D

Dennis

Yes you can. How depends on where or how you want to see this total. If you
simply wish to see it, then create another query based on your first query.
Select the one column and then click the totals button on the toolbar. Change
group by in your query column to Sum and then run the query.
If you wish to see the total in a box on a form then in the control source
of the box
put the following
=DSum("ColumnName","QueryName")
 
J

jojo

Thank you Dennis - I'll try this

Dennis said:
Yes you can. How depends on where or how you want to see this total. If you
simply wish to see it, then create another query based on your first query.
Select the one column and then click the totals button on the toolbar. Change
group by in your query column to Sum and then run the query.
If you wish to see the total in a box on a form then in the control source
of the box
put the following
=DSum("ColumnName","QueryName")
Click to expand...
 
J

jojo

This didn't work. It added the column across. I have 60 records (patients)
in my query - 7 columns (labeled MON,TU,WE,TH,FR,SA,SU). Each patient is
seen various times during the week. I'm trying to calculate how many hours
are scheduled for Mon, then Tues, etc.

Thanks
 
Top