Create a Query to pull a list of records from large DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Table 1 has 1 field and 20 records (unique tracking nos.). Table 2 has 8
fields and 900+ records. Field 7 of Table 2 contains the unique tracking
nos. -- 20 of which are found in and comprise Table 1. I want to do a query
that will pull only the records from Table 2 (with all 8 fields) that match
the 20 unique tracking numbers found in Table 1.

Can anyone help?
 
Create a query that includes both tables. Join the field in Table 1 to Field
7 in Table 2. The query will return only the records you want.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Table 1 has 1 field and 20 records (unique tracking nos.). Table 2 has 8
fields and 900+ records. Field 7 of Table 2 contains the unique tracking
nos. -- 20 of which are found in and comprise Table 1. I want to do a query
that will pull only the records from Table 2 (with all 8 fields) that match
the 20 unique tracking numbers found in Table 1.

Can anyone help?
Click to expand...

Create a new Query in the query design window. Add Table1 and Table2. Drag the
TrackingNo field from Table1 to the matching field in Table2. Select the eight
fields in Table2.

This query will display only those records from Table2 which match Table1. You
may well get more than 20 records - for instance, if you have a dozen records
in Table2 which contain 123 as a tracking number and that's one of the records
in Table1, you'll see all dozen.

John W. Vinson [MVP]
 
Back
Top