Question about the Delete Dupes Query..

  • Thread starter Thread starter Jeff Rush
  • Start date Start date
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
 
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
 
Back
Top