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
 

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

Similar Threads

Dupes in one column in table - is this possible?? 5
duplicates query 2
query that doesn't select dupes 2
Duplicate Find not finding all dupes 3
Delete Dupes Question 2
Could not delete from specified tables, again 7
ACCESS DB help - using delete button on form and does not delete. 5
Bizzare delete query problem 15

Top