if access query has no records, output "no records found"

  • Thread starter Thread starter Guest
  • Start date Start date
right now I have a macro that runs a query, saves it in excel format and is
emailed as an attachment. If there are no records, I would like "no records
found" to be placed in the first cell in an excell spreadsheet and emailed as
an attachment.
 
I think you need to create a table with a single field and record with the
value "no records found". Then test your query for records prior to running
the macro and either send the query or a query of the No records found
table.
 
Back
Top