SELECT Query Help - Multiple Records

[Jordan M.]

Hi,

Hoping to get some help modifying the following query that I have...

TABLE: NAMES
ID, FirstName, LastName

TABLE: EMAILS
ID,LinkID,Email,LastUpdateDate

I have two tables, one of Names, one of Emails. Each person only has
one record in the Names table. Each person however, may have multiple
email addresses in the Emails table. I want to pull a query that
returns a person's name, and the latest email address on file.

I am able to successfully pull a full extract that shows names and
emails, but I can't figure out how to limit it to the latest email
address. So in essence, I am getting a row for each name for each
listed email. Which means some names appear multiple times because
they have multiple, older, email addresses on record.

How can I limit this?

THANKS!

[John Welch]

Jordan, what you need is a query that will show the latest email ID (by
date) for each value of LinkID, so you can then join the Names table to
that query. For help on that, see this article:
http://www.mvps.org/access/queries/qry0020.htm

-John

Jordan M. wrote:

Hi,

Hoping to get some help modifying the following query that I have...

TABLE: NAMES
ID, FirstName, LastName

TABLE: EMAILS
ID,LinkID,Email,LastUpdateDate

I have two tables, one of Names, one of Emails. Each person only has
one record in the Names table. Each person however, may have multiple
email addresses in the Emails table. I want to pull a query that
returns a person's name, and the latest email address on file.

I am able to successfully pull a full extract that shows names and
emails, but I can't figure out how to limit it to the latest email
address. So in essence, I am getting a row for each name for each
listed email. Which means some names appear multiple times because
they have multiple, older, email addresses on record.

How can I limit this?

THANKS!