Delete records based on criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Andy (Hypnotic_Monkey_Scratcher) said:
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.
Click to expand...

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

Tom Lake
 
Back
Top