Help on Record Count

W

Wayne Morgan

This query will do it, adjust the table and field names.

SELECT Count(Table1.A) AS CountOfA
FROM Table1
HAVING (((Table1.A)=True));

You may also want to look up the DCount function in the help file.
 

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

Macro to Select text from a point given to a specific word 2
Loop until end 1
Section and Page numbering 0
Select Text to End of Footnote 9
Making a macro only work on certain files 2
How to count the numbers in a Word document? 0
How to display zero value in blank fields of Cross Tab query 0
Dcount -Date Criteria - Won´t find it - 0

Top