Query totals

[kaluapig]

Good day!

I am a total newbie at Access and have a question.

Is it possible to run totals off of a query?

For example:

I have a simple test table with 3 fields:
ID <autonumber>
Field1 <number>
Field2 <text>

I'd like to run a query that filters out records based off of field2 and count & sum the occurances from field1.

What I did before (that didn't work) was make a query containing a sum column for Field1. This only gave me a listing of records with the same number that was in Field1 to begin with.

HELP!?!

 

[Obiwan4210]

You'll probably need to use Field 1 from your table twice. In Design View enter the appropriate search criteria in the Criteria row under the Field 2 Column of your Query in quotes. So if you want to look at apples, enter "apples". In the first Field 1 column go to Total: row and select Sum. In the second Field 1 column in the Total row select Count, and let the fun begin.