totals query

[Guest]

I'm pulling my hair out. I know the answer has got to be simple because I
feel this is a simple question.

I have a table I would like to build a query from, but use one field as the
criteria. The field, "table" has 3 possible entries from a drop down menu,
Maintenance
Conversion
New Purchases
I want to get the sum of the "amount" field for each one. How can I do this?

Thanks!

Troy

 

[Guest]

hi,
it is simple.
in query design mode, click the sigma symble on the tool
bar. this will and a new "totals" row to your query.
in the amount field, click into the totals cell. a down
arrow will appear. click the arrow then click sum. in the
other field "table", click group by.
make sure these are the only 2 fields in the query.

see my post reply to M.R. posted at 6:12am in queries.(5
posts down from you) he had a simmilar problem. i
explained more about group by and aggragate functions.
regards
HDR