Query record set greater than null???

[Muzicmn]

What I need to accomplish is an alert if a query finds any records. In other words, When the main page is loaded a query will run in the background. This query is looking for any records that need to amended within the next 30 days. What i would like to do is if the query finds any records that need amending an alert "form" or conditional formatting in a field with turn it red as an indicator that attention is needed.

My problem is how do i write a code to see if the record set from the query is greater than null???

any ideas would be greatly appreciated.


Ricky

 

[pbaldy]

Simplest way:

If DCount("*", "QueryName") > 0 Then
  'query returns records
End If

 

[Muzicmn969]

thanks will give it a shot