Question about how to structure a particular Access query

A

angrymob

OK, here's the deal. I have two data tables, one of which holds many types
of customer information and has a very large number of records, including,
name, address, phone, and email. The other table contains only email
addresses. Each email in the second, smaller table corresponds to a record
in the larger list , by virtue of both records sharing the same email address
(primary key?). I need to be able to take a short list of email addresses
from one table and produce all of the records from the larger table that have
corresponding email addys, essentially. Can somebody shed some light on how
I can structure a query to solve this dilemma? Sorry for the newb question,
just getting started out using db's.. Thanks!
 
J

John Vinson

OK, here's the deal. I have two data tables, one of which holds many types
of customer information and has a very large number of records, including,
name, address, phone, and email. The other table contains only email
addresses. Each email in the second, smaller table corresponds to a record
in the larger list , by virtue of both records sharing the same email address
(primary key?). I need to be able to take a short list of email addresses
from one table and produce all of the records from the larger table that have
corresponding email addys, essentially. Can somebody shed some light on how
I can structure a query to solve this dilemma? Sorry for the newb question,
just getting started out using db's.. Thanks!
Click to expand...

This is bread and butter for an Access query.

Create a new Query. Add both these tables to the query grid.

Drag the EMail field from one table to the other.

Select whichever fields you want to see.

Open the query and you're there...

John W. Vinson[MVP]
 
Top