Search results for query: *

TO rjoupert & PHV, OK, I FINALLY got it to work! Thanks, Phil....

rjoupert, Thanks for your reply! I copied Table1 structure only & saved as Table1_Copy...worked OK. Cannot assign keys to multiple fields in Table1_Copy (Name and DOB) as Access only allows one key in a table. Any ideas here? Thanks, Phil....

I need to remove repeating instances of records where the Name and DOB field values are the same. Other field values in these same records are different, so the records are not exact duplicates, but similar. I'd retain in the table the first instance of a similar record. Is there a script to do...

IT4EVR, Thanks for the clarification. In the Update query grid, the 'Table' row and the 'Update to' row should each refer to different tables, right? So I have in 'Table' row, reference to the original table, and in the 'Update to' row, the TempTable. Is this correct? The query runs but the...

Well, as the table sits now, I have records containing the same Name & DOB that were entered multiple times for different reasons, in this case, different offenses. So some fields defining the various offense data would be different for each record. What's needed is a listing so each Name & DOB...

IT4EVR, My appologies about multiple posts. Can you answer the question in my last entry above regarding Cherrio's method? Thanks, Phil....

Cherrio, ...you are correct in what is similar: LastName, FirstName, DOB (ref your paragraph 2). I've got everything done but need help in what you describe in paragraph 6, the one that starts with "Now create an update..." I can create an update query but what needs to be done to join the...

First off, special thanks to IT4EVR and PHV and Vic for their aide. Problem is, I'm not sure I stating my problem correctly. Here goes again: I have ~165K records with some records similar. I want to delete the similar records and retain the first instance of the record. As mentioned, one thing...

Vic, Thanks for the latest script. I know something about Access but have had no formal training in in sql scripting, which I see is far more powerful and flexible than simply using Access built in wizards, etc. One thing that's been a pain about this effort is that some of the records in the...

Vic, OK, got the original table with all 'true' fields deleted. So this table is missing one record from each similar record set. Here's the prob: The duplicates table (temporary table) creates 1 record for similar records only if I include just the fields in question: (LastName, FirstName...

PHV, ...not yet but I appreciate your continued monitoring of this effort. Phil.....

IT4EVR, In you above posts, I'd keep 1st instance of record and delete all others. I tried indexing the table based on ID field, which is autonumber format, but app still hangs.

This looks good but in the above script you SET tblOriginal.DeleteMe = "True" But isn't the DeleteMe field created in tblTemporary table? This is what I did per your step #3. Please advise. Phil....

Vic, I'm good to go and have competed through your step 3 (above). The temp table has 1995 records. Some records appear 2 times, some 3 ...up to 5 occurances. I then created DeleteMe as a text field, but how do I script or complete your Step 4? Phil....

Below is your script, modified for my table (Table1 = Crim_Table_rev & DOB = DateOfBirth). All other syntax was left unchanged. Other info: 1. No error messages, script seems to run but app simply hangs..yup screen freezes. I can kill the app in Task Mgr though and recover to desktop without...

How can I delete similar records in Access? There's the info: In a large table (~165k reocords) are many occurances of two or more records where the LastName, FirstName, and DOB fields all match, ie, these are not duplicate records where all fields match. I want to delete similar records...

IT4EVR Thanks for the quick repsonse! I used your script, modified as required. But Access hangs! Is there maybe a more straight forward but less elegant way to script this? Phil...

How can I delete similar records in Access? There's the info: In a large table are many occurances of two or more records where the LastName, FirstName, and DOB fields all match, ie, these are not duplicate records where all fields match. I want to delete similar records, leaving one unique...