deleting temp tables

[lynne]

I have a macro that creates several temporary tables and
then deletes them at the end. The problem is that one of
the tables isn't created all the time so when macro gets
to the delete line I get a halt because it can't find the
table I've told it to delete. How can I create a
conditional delete - if the table is there, delete it
else skip the delete and continue?

TIA,
Lynne

 

[Jim/Chris]

In the Conditions part of the delete statement

DCount("*","tablename")>0

Jim