Limiting results of a union query

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Save the UNION query as a named query. Then use that as the record source
for a query that filters the records based on latest message date and time.

Are message date and time really stored as two separate fields, or are they
just being displayed that way?
 
I don't understand what you mean by "named query". Yes, the date and time
are stored in two separate fields.
 
Back
Top