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" <[email protected]> wrote in message
news:[email protected]...
> 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