Question about the Delete Dupes Query..

J

Jeff Rush

Hi all,

I am wodering how the query itself works. I have a table where I have
randomized the records order and am wondering if I run a delete query will
sort the table dierently while checking for dupes and deleting them.

If so I need to randomize the table after the dupes and deletes are
complete.

TIA for your help,

Jeff Rushing
 
G

Gary Miller

Jeff,

As a query is just a 'view' of the records in the table, it
shouldn't change the order after deleting records. You can
always make a copy of the table to do the delete on to test
the behaviour.

Gary Miller
Sisters, OR
 
Top