By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,454 Members | 3,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,454 IT Pros & Developers. It's quick & easy.

SELECT Query Help - Multiple Records

P: n/a
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!

Aug 8 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!
Aug 8 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.