Is there a way to determine if a table is empty?

[robojeff]

Is there a way to determine if a table is empty?

I have a query which creates a table and then I attempt to take the data from the table and place it into an excel worksheet but if the table is empty (no records) I get a "No data error..."

How can I test the table and divert my code from attempting to dump this data into the excel file or a graceful way to rebound from this without stopping the code and/or confusing the user?

thanks

 

[PHV]

Have a look at the DCount function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886