Number of records in a query.

[Ayo]

How do I find out how many records are in a query using VBA codes?

 

[Allen Browne]

Try:
DCount("*"), "Query1")

Substitute your query name for Query1.

 

[Douglas J. Steele]

Slight typo there.

It should be

DCount("*", "Query1")

 

[a a r o n . k e m p f]

or if you're using SQL Server SELECT @@ROWCOUNT right?

THanks

-Aaron