Match Query

[Barb]

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]

Answered in m.p.a.modulesdaovba

 

[Douglas J. Steele]

And m.p.a.developers.toolkitode!