duplicate records update field with max date

[tsokawil]

I have duplicate records with different event dates in the date field and I am trying to use the update querry to update table with the max date on each set of duplicate records. I have created a table with just the duplicates.

Could anyone help let me know how to make this happen.

Thanks

 

[Beetle]

Do you want to delete the duplicates with the older dates, or are you trying to update them so that the event dates are all equal to the max event date?

 

[tsokawil]

Yes so that the event dates are all equal to the max event date.

 

[Beetle]

Note: If you want to try this, do so on a backup copy of your database in case you don't get the results you want.

You don't need to (and shouldn't) put the duplicate records in another table in order to do this. Just create a query that returns the duplicate records, then update the query with something like;

Update [YourDuplicateQuery] Set [EventDate] = DMax("[EventDate]", "[YourDuplicatesQuery]", "[EventID]=" & [EventID]);

 

[tsokawil]

thanks, I will give it a shot.

 

[Beetle]

Now that's what I call a delayed reaction.