What is the Access equivalent of Excel's COUNTIF?
 

I'm preparing a quick report in Access (which I've never used before). I
just need to display totals for each value in a column...they're selected via
a combo box, so it should be easy....thanks!

BTW, this wouldn't let me post in the Access forum for whatever reason.

"RedStep" wrote in message
...
I'm preparing a quick report in Access (which I've never used before). I
just need to display totals for each value in a column...they're selected
via
a combo box, so it should be easy....thanks!

BTW, this wouldn't let me post in the Access forum for whatever reason.

Do you need some kind of SQL statement? It would be something like

select count(*) from SomeTable where SomeColumn 0

/Fredrik