Totaling a query field (access 2000; XP)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
---


bob s said:
I used query Wizards for designing, then added Criteria. My query selects
Click to expand...
the proper batch of records (approx 20)
 
Back
Top