totals query


G

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Totals Query 1
Totals Query 10
Totals Query 2
Totals Query 3
Query Totals 3
Query Totals 1
Query for totals 9
Totals Query 2

Top