Question about the Delete Dupes Query..


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

TIA for your help,

Jeff Rushing

Gary Miller


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question