If query has not records -"no records found" to be output in query out/report

Giganews Newsgroups
Subject: If query has not records -"no records found" to be output in query out/report
Posted by:  scottmacha…@cox.net
Date: 23 Aug 2006

I am currently running a marco that run a query and emails the results
as an attachment in excel format.  If the query has no records, I would
like to email "no records found" in the first cell in the excel
attachment.  I have a feeling that this needs to be done in VB, but I
don't know that much about VB.  Would using a report instead be a
better and easier way of doing this?

Replies