Counting records in an already made query 1

[daveonion]

Hi I have a query that has already been created and i want to count the amount of records in that query, whats the easiest way to do it,

I thought i could do

x = CurrentDb.QueryDefs("myquery").recordcount

but evidently i cant, any help as always appreciated
thanks

 

[smedvid]

My approach would be to create a RecordSet with the predefined Query or Create a RecordSet with a Select Count(*) against the predefined query. hthw,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[PHV]

Another way:
x = DCount("*", "myquery")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[daveonion]

Hi I was using Dcount originally, but hadnt thought of putting * there, thanks the * is worth a *, how corny is that