What is the Access equivalent of Excel's COUNTIF?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Equivalent of Access "Load" Event? 2
What is keyboard shortcut equivalent to drag the fill handle 2
what is FileDialog equivalent in Access 97? 5
My Excel file is not calculating! 13
COUNTIF Question 3
Excel Urgent help in Excel / Access Report 0
What is the VBA equivalent of the excel function VLOOKUP 4
Is a dynamic/live link INTO Access FROM Excel possible? 3

Back
Top