how can i get this total

[Matrix_zero]

Is there a way to pull a total number out of a table using a query.

My db has recent tax assessments broken down by class, the problem is it is all together and i don't need each class i only need the total.

How can I say:

For table "2004Assessment"
Give me the total in colum 2 whare colum 1 = 011-990

 

[jjturner]

Did you try a totals query?

SELECT Column1, Sum([Column2]
FROM 2004Assessment
GROUP BY Column1
HAVING Column1 = '011-999'

(or if '011-999' represents a range of possible field values, the last part would be "HAVING Column1 Between '011' And '999'")

HTH,
John