Totaling a query field (access 2000; XP)

[bob s]

I used query Wizards for designing, then added Criteria. My query selects the proper batch of records (approx 20)
Now i want the query to total the ~20 amounts listed in the SELLAMT field.
After much struggling, Can't seem to find the proper way to go.
Ideally, an appropriate (additional) instruction seems to be required in the Design View screen.
Any suggestions will be appreciated

 

[Troy Berardo]

Depending on the fields used in your query and whether or not you need to
access any of the information in there or just want a total and that's it,
you can take a look at Grouping within that query, or you can create a new
query based on the one you have to return the Sum of one of the fields.

Troy
---

I used query Wizards for designing, then added Criteria. My query selects

the proper batch of records (approx 20)