Match Query

[Barb St. Clair]

I have two tables (related) and I want a query that will show records when
two fields match from each table, two from table one, two from table two.
Table1 Table2
Last Name Last Name
Item# Item#

Any suggestions?

 

[Allen Browne]

1. Create a query into both tables.

2. In the upper pane of the query design window, drag Table1.[Last Name]
onto Table2.[Last Name]. Access shows a line joining the 2 queries.

3. Repeat step 2 for the [Item#] field. You now have 2 parallel lines
joining the two tables.

It would probably be a better structure to create a Client table, with
fields for ClientID, LastName, etc, and then use the ClientID instead of
Last Name for this join. That would prevent you from getting all the items
for all the Smiths mixed up.