two tables one query.

  • Thread starter Thread starter Professional_in_need_of help
  • Start date Start date
P

Professional_in_need_of help

I have the following info and I want to create a query.

[tblPayment]![strLCNumber]
[tblIRB]![strLCNumber] and [tblIRB]![strAltRef]

I want to do the following:
Search tblIRB where both [tblPayment]![strLCNumber] & [tblIRB]![strAltRef]
equal each other, but get the information attached to [tblIRB]![strLCNumber]
& [tblIRB]![strAltRef] equal each other.

I hope that makes since!!!
 
SELECT *
FROM tblPayment INNER JOIN tblIRB
ON tblPayment.strLCNumber = tblIRB.strAltRef



Hoping it may help,
Vanderghast, Access MVP


"Professional_in_need_of help"
 
Back
Top