Append Query

[uksoldier]

I'm using an append query to move "customers" with a certain criteria.

The move is happening when I run the query but I want it also to take off the "customers" from the main table.

is this a manual thing ? Will it leave the filtered customers on the destination table ?

thanx for now...

 

[Rich]

Use the same criteria to run a delete query

 

[uksoldier]

Ok... Delete Query

So I run the Append Query...

Then run the Delete Query...

The append query will move the customer to the destination table

the delete query will delete the customer from the main table

and the moved customer will stay in the Dest Table ????