Getting count of records in Access97 vba

B

BarbaraH.

I have tried many different tools to get a count of a
subset of records in a table. These include DCount,
DLookup, and RecordCount of a recordset.
All have failed me due to the same problem. I can't get a
date comparison to work.

However, I am able to accurately get a count of records
using a DoCmd.OpenQuery statement with a query that
somehow can handle the date comparison correctly. I tried
posting a question on help for why the date comparison
isn't working, but no one answered.

So my question here is: is there any way to return the
count total from a DoCmd.OpenQuery statement that comes up
with a value in a CountOfFieldName field?

Thanks for any help or suggestions you may have.
 

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

Count Records for this week, this month, this quarter, this year 5
Excel VBA - counting cells by colors and names to it in two different rows. 0
count visible records only on continuous forms 2
RecordCount problem 2
Count Records in DLookup 3
Access Module 15
Count number of rcd on continuous form. 3
Count number of records by date 2

Top