hi,

i tried doing a delete query earlier on and it still doesnt work, so this is the latest idea.

I have two tables of data, both of which have a unique number, which may be on both tables.

I want to run an append query which will take all of the records on one table, EXCEPT those which are on the second table. Please help me with this one as i am getting really frustrated as the NOT expression seems not to work.

I have tried = NOT [ value on second table ] in the criteria, but it doesnt work?? why?

thanks a lot.
Sparky