check empty table

[ramdandi]

how to put condition in a macro to check if the table is empty then throw error else process query?

[orange]

I don't use macros but you should investigate DCount() function.