Deplete records from a table with every successive query

  • Thread starter Thread starter MJ
  • Start date Start date
M

MJ

Hi,

I have a table (that was created as a result of a make-
table query based on certain criteria).

I then have a set of 10 queries in a certain sequence. I
want to run these queries against that table such that
everytime a query is run, it depletes the table so that
there are no duplicates in subsequent queries and at the
end the table is blank. The individual query results will
be captured (exported to excel) so data is not lost.

Does anyone know how that can be done. Or recommend
another (better) method to achieve the result which is not
to have duplicates in the different queries.

Thank you so much !
 
REALLY hard to say. But it sounds as if you need to run two queries for each action.

Run your current query 1 and then use that as a basis for a delete query.
Run query 2 and then use that as basis for a delete query.

Alternative would be to add a boolean field and mark it true when you've used a
row and then add that field as part of the query to eliminate any records marked
as "Used".
 
Back
Top