Limiting results of a union query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stan - 29 Sep 2005 17:51 GMT

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?

Reply to this Message

Chaim - 29 Sep 2005 18:07 GMT

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?

--

Chaim

> 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?

Reply to this Message

Stan - 30 Sep 2005 15:28 GMT

I don't understand what you mean by "named query". Yes, the date and time
are stored in two separate fields.

> 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.
[quoted text clipped - 15 lines]
> these
> > duplicates occur and only apply to the near duplicates. Any thoughts?

Reply to this Message