Delete records based on criteria

[Andy (Hypnotic_Monkey_Scratcher)]

Hi

I need to write a macro that will delete records from the output of a query,
based on the value of one of the fields.

The main problem I am having is that the criteria for deletion is over 2700
'things' long. Is there a way I can compare the value of the field to this
list, and if it matches, delete the whole record?

Any info would be much appreciated!

Thanks & Regards,

Andy

 

[Eric Blitzer]

I do not know what a "things" is but can't you use a delete query?

 

[Andy (Hypnotic_Monkey_Scratcher)]

Basically, I have lots of cost data, and need to delete the data for some
projects (the 'things').

I tried creating a delete query, but there is not enough space for all of
the criteria.

 

[Tom Lake]

Basically, I have lots of cost data, and need to delete the data for some
projects (the 'things').

I tried creating a delete query, but there is not enough space for all of
the criteria.

Create a table with the 2700 'things' in it and run the delete query based on a
DLookup criteria from that table.

Tom Lake