Auto email query

[warrigal]

Hey all



I have set up a number of queries that are run once a week and the results are emailed to various people. However these queries are ones that will always return results. I now have a query that will not always return results. I would only like to send an email if the query returns results. I still run it each day automatically, checking for due dates within 2 days of the current date.

Cheers

[pbaldy]

You can use DCount() to test the query, and only send the email if the result is >0.

[warrigal]

Thanks Paul, still having issues.

I created a DCount expression in the query I am running using the due date as the expr and the table name as the domain. I haven't used any criteria (not sure if this is correct). There are 2 records that come up (which is fine and correct) but the count is 2659 for both of the records. I am unsure where this number comes from...

[pbaldy]

Well, you probably don't have a criteria on the DCount. However, I didn't mean to include it in the query. In the code where you're sending the emails:

If DCount("*", "QueryName") > 0 Then
  'your code to send the email
End If