Finding Number of RecordsAffected in a Select Query

  • Thread starter Thread starter OceansideDJ
  • Start date Start date
O

OceansideDJ

I am using db.execute... then db.recordsaffected, but Access is telling me it
does not work in a Select query. How can I find the number of records
selected in a select query? In a table?

I want to show to the user "n of m records updated."

Thanks,

Mike
 
Hi Mike,

For the number of records that will be selected by a select query, you
can use

DCount("*", "QueryName")

Substitute the name of the table for a count of the number of records in
the table.
 
Back
Top