G
Guest
My query returns records with 14 fields of data. My problem is that, under
certain circumstances, it will return records that are basically duplicate.
The first twelve fields are the same, but the last two (message date and
message time) are different. What I would like for Access to do is only
return the record with the latest message date and message time, when these
duplicates occur and only apply to the near duplicates. Any thoughts?
certain circumstances, it will return records that are basically duplicate.
The first twelve fields are the same, but the last two (message date and
message time) are different. What I would like for Access to do is only
return the record with the latest message date and message time, when these
duplicates occur and only apply to the near duplicates. Any thoughts?