Duplicates in Query

L

Louise

I have a query that pulls from one table, I want to delete records where the
IDENTIFIER field is a duplicate, and there is data in a FROM_TO_PD field, if
there is no information in the FROM_TO_PD field I do not want to delete the
record

I have tried using Where IDENTIFIER = IDENTIFIER and FROM_TO_PD is Not Null,
but it keeps wanting to delete all the records.

Can you help please
 
R

Roger Carlson

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "RemoveDuplicates.mdb" which illustrates how delete uuplicate
records with a query. You would have to add the additional criteria
requirement. You can find the sample here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=285

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 

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

Could not delete from specified tables. 3
Combining queries that don't match 0
Autolookup Query to find Multiple Records 3
mark duplicates 6
Help finding duplicate records across 8 quarters of data 3
Update Query - Want to Update Only the First Match 4
Combine Duplicates in Query 0
Delete Dups Query Failing 3

Top