# of records returned by query

  • Thread starter Thread starter SMatthew
  • Start date Start date
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...


..
 
If you bound the query to the form with the form wizard
then you can use the Me.RecordsetClone.RecordCount = 0
 
DCount("*", "YourQueryName") should give the number of rows/records returned
by your Query.
 
Back
Top