Thanks for the answer, Richard, but take it one step further please.  Once I can see 100 "pairs" of records after the query, I know I can mark one in each pair, one at a time, hit "delete", verify it, and then move on.  But can I click on one in the first pair, then hold it while I click the next, and the next.  As with field attributes and moving them, there is a Shift+click and sometimes there's a control+click.  So the question is, how can I hold them and not have to hit delete and "Y" each and every time?  Or can't I?

While I'm at it, my zipcode field (Imported from a dbase) is 10 bytes with the full zip.  Is there a way I can split it to two fields, 5 + 4 once it's already in Access?  In Foxpro, I could export Left(zip,5)+" "+substr(zip,7,4) and get it split into a csv or sdf file.  But can I do it in Access?  
P.S.  I'm in the middle of Level 2 and plan to keep going.  Thanks.  You're a good teacher.
david krongelb

---

Reply from Richard Rost:

Nope. Sorry. You can't CTRL-click specific records in a table or form. There are some more advanced tricks you could pull to automatically delete the duplicates, but it would be easier to explain them to you once you have a little more Access under your belt. You could use a DCOUNT function to determine how many there are, then use DMAX to delete the higher of the two. Again... much more advanced.

Yes, there are also LEFT, MID, and RIGHT functions in Access. You would basically create two new fields in your table (ZIP and ZIP4) and then with an UPDATE QUERY set ZIP to Left(ZipCode,5) and ZIP4 to Right(ZipCode,4). SEE THIS.