Ok, this is super complicated in my mind....but it could be a simple solution i am not seeing.
I have two tables in a left join and i have one set of numbers that has multiple matches of a different set of numbers. For example:
Qpin Lpack number (primary Key)
9555 95555555
9555 95555555
9555 95550000
9555 95550000
The table on the right has the multiple Lpack numbers and the table on the right has the Qpin numbers. Do i need to do an expression or perhaps break it down into more queries/tables?
This is the expression I used and it did not work
IIf([table name tbl.lpack]=[table name.lpack] And [table name.opin]=[table name.opin],"yes","no")
it gives me this result:
Qpin Lpack number (primary key)
9555 95555555
9555 95555555
I need a way to flag all of the Qpin numbers that have different Lpack numbers...Would an expression work, and if so what? grrrr this one has FRUSTRATED me! Thanks guys.
I have two tables in a left join and i have one set of numbers that has multiple matches of a different set of numbers. For example:
Qpin Lpack number (primary Key)
9555 95555555
9555 95555555
9555 95550000
9555 95550000
The table on the right has the multiple Lpack numbers and the table on the right has the Qpin numbers. Do i need to do an expression or perhaps break it down into more queries/tables?
This is the expression I used and it did not work
IIf([table name tbl.lpack]=[table name.lpack] And [table name.opin]=[table name.opin],"yes","no")
it gives me this result:
Qpin Lpack number (primary key)
9555 95555555
9555 95555555
I need a way to flag all of the Qpin numbers that have different Lpack numbers...Would an expression work, and if so what? grrrr this one has FRUSTRATED me! Thanks guys.
Last edited:
