Recent content by nad341

I have 1-2 fields in the duplicate records that do not match. So, using distinct would not be helpful. The actual table from where these records need to get deleted has additional fields that match. I tried copying the structure, defining primary key and appending the records from the current...

Hi, I have a table that has multiple records (count >1). I used the find duplicate records and then made it a delete query, however, this resulted in deleting all the records that had count >1. I need to retain distinct record, and delete the extra records. Using select distinct... is not...

Hi Bob, Thanks for your reply. Very helpful.

Hi, I need to update the periodtype field in my table depending on different values in the field Formtype- I am looking to do this without having to use VBA. I have the following fields in a table - I want to update the value of the field Period_type as follows - When Formtype is 10-Q, update...