Re: Match Query
From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: Fri, 2 Jul 2021 07:28:13 -0400
Assuming you're creating the query through the QBE query builder, drag both
fields from table1 to table2 so that there are 2 lines between the tables.
The SQL will look something like:
SELECT Table1.Field1, Table2.Field2, Table3, Field3...
INNER JOIN Table2
ON (Table1.[Last Name] = Table2.[Last Name] AND Table1.[Item#] =
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Barb St. Clair" <firstname.lastname@example.org> wrote in message news:ZR4Fc.10834$wY5.4880@attbi_s54... > 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? > > -- > -Barb > email@example.com > > >