What is the Access equivalent of Excel's COUNTIF?

R

RedStep

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

Fredrik Wahlgren

RedStep said:
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.
Click to expand...

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

select count(*) from SomeTable where SomeColumn > 0

/Fredrik
 
Top