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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Just as it says: if access query has no records, output "no records found"
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting records in a query 9
Show weeks a record has met query criteria 1
Access 2010 append query to SQL is very slow 0
Access Query - "Duplicate Records Selected" 5
query is not updatable;; urgent 1
default query result 1
Pipe character in query in VB6 app 11
Problem with query output 1

Back
Top