Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel and Access talking | Excel Discussion (Misc queries) | |||
Getting Excel's charting capabilities from Access | Excel Discussion (Misc queries) | |||
Excel countif based on size of numbers in one column in Access | Excel Worksheet Functions | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |