Combine lines of totals into one line with totals

[ajhts]

I have a query that pulls total minutes by payor type. It looks like this:

Day# PartA PartB Other
1 65
1 20
1 36

How do I make this one line with the totals, example

Day# PartA PartB Other
1 65 36 20

Any Ideas?

Thank you very much!
AJ

 

[traingamer]

one way:

Select Day, Sum(nz(PartA,0), Sum(Nz(PartB...
group by Day

traingamer

 

[ajhts]

Where do I place this code? Where in the query?

Sorry to bother you again,

AJ

 

[lespaul]

switch to the SQL view of a query, copy & paste the SQL, change the table and field names and then run the query.

Leslie