Queries: Missmatch

[JWT]

Queries: What would be the best way to,
I have two tables that do not match. I put in this Expr 1: Right([P/N].2) that is the only item to return data to match the other table. Want to know how to trigger or make the other table enter only the information needed. The small table has eight items with three columns and makes the displayed information repeat eight times. All the but the customer code number comes from one table and just too many customer code numbers to add in to its table.
Would Union or SQL be a way to make this work?
Let me know if anyone has a better way, Thank you. JWT

 

[Pat Hartman]

Switch to SQL view so you can specify the join you need. Once you modify the join, Access won't be able to represent the new join in the QBE grid so you'll have to live with SQL view for this query.

Select ...
From tblA InnerJoin tblB on Right(tblA.[P/N].2) = tblB.SomeField;

 

[JWT]

Thanks for the help. JWT