Count of field where field =

[macking]

How do you write a statement to get the count of a field for wherever that field is = to XXX ?


To try to make my question a little better look at it like this:

My Table:

Server / User / DateTime / Action

Row 1: miami1 / carlosj / 05-04-2010 11:23:31 / Exported source
Row 2: miami1 / davidc / 05-04-2010 11:24:41 / Ran DB import
Row 3: denver7/ carlosj / 05-04-2010 11:27:29 / Exported source

I need to have all of the servers grouped in my report.



Under each grouping I need several totals for exampe: total count of action where action = Exported source

But I don't want to write a separate query for each total for each server.

Can Access know that I am on the group miami and pull the count for action where = exported source?

Thanks again for your expert help

[ajetrumpet]

How do you write a statement to get the count of a field for wherever that field is = to XXX ?

to answer this question, it would be:

select count(field) from table

where field = xxx