Running a saved query

[John]

Hi

I need to run a saved query and just need to know if there are any records
returned. Not interested in actual records. What is the easiest way to do
this?

Thanks

Regards

 

[Douglas J. Steele]

If DCount("*", "NameOfSavedQuery") > 0 Then
' there's data
Else
' there's no data
End If

 

[Guest]

I would use code like:
If DCount("*","[a saved query]")>0 Then
msgbox "There are records"
End If

 

[Guest]

You could use the DCount function to return the number of rows, e.g.

If DCount("*", "YourQueryName") > 0 Then
MsgBox "Query returns rows."
End if

Ken Sheridan
Stafford, England