# of records returned by query

S

SMatthew

I am executing the query behind a form.
But would like to make some changes in the code to do
some calculation for that would I be able to get the
number of records returned by the query.
Thanks

Subject: Re: # of records returned by query
From: "JohnFol" <[email protected]> Sent: 1/2/2004
6:42:22 AM


Yes. How are you executing the query?
In code, behind a form, as a macro???

message
Is there a way to find the number of records returned by
a query?
Click to expand...


..
 
G

Guest

If you bound the query to the form with the form wizard
then you can use the Me.RecordsetClone.RecordCount = 0
 
V

Van T. Dinh

DCount("*", "YourQueryName") should give the number of rows/records returned
by your Query.
 
Top