counting query recordds

  • Thread starter Thread starter mark kubicki
  • Start date Start date
M

mark kubicki

what's the most efficient way of getting a count of all the records in a
query?
=count()?
count(*)
...

I will be using that number on a form which also contains the data that will
be called in the query...

thanks in advance,
mark
 
mark said:
what's the most efficient way of getting a count of all the records in a
query?
=count()?
count(*)
...

I will be using that number on a form which also contains the data that will
be called in the query...
Click to expand...


Count(*) is way faster than any other way, but it is oftern
easest to use it in a form/report header/footer text box
instead of a query.
 
Back
Top