Ok ,so I have identified the prob.,but I dont know how to fix it.
I have 2 tables,that r linked by a left to right join on 4 fields.
The idea is to pull a value from the second table (that paricular field is not joined).
On occasions one or more columns in each table may have a null value in one of the fields.
I have tried using "Is not null",but that results in the query finding an alternative item where everything is similar except the null value field ,resulting in the wrong and /or duplicate values being extracted.
I have thought about filling in the nulls in both tables with an alpha or samething,but that long term is tedious as hundred of items r added weekly.
Any suggestions on how to extract the exact item required welcome please.
I have 2 tables,that r linked by a left to right join on 4 fields.
The idea is to pull a value from the second table (that paricular field is not joined).
On occasions one or more columns in each table may have a null value in one of the fields.
I have tried using "Is not null",but that results in the query finding an alternative item where everything is similar except the null value field ,resulting in the wrong and /or duplicate values being extracted.
I have thought about filling in the nulls in both tables with an alpha or samething,but that long term is tedious as hundred of items r added weekly.
Any suggestions on how to extract the exact item required welcome please.
