Skip if Query is NULL 1

[psarros]

Hello

I have some code that I run and I want to skip the code if the query [qryPopulateTempReport] is null.


Thanks in Advance!!!

 

[PHV]

What is your meaning of a null query ?
A query that that returns no record ?
You may consider the DLookUp or DCount function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[psarros]

Yes, if my query returns no data, I want to Skip the code.

 

[psarros]

Thanks

Dcount was all I needed!!!!