VB Query

Chris · May 11, 2004

I am running a query and outputting it into Excel then
sending the spreadsheet in an email in VB code. How do I
cancel the email from sending if the query returns no
records?

Thanks

-Chris

Chris Nebinger · May 11, 2004

IF DCOUNT("*","QueryName") > 0 then
'....Code to email it.
End IF

Chris Nebinger