Last post Mar 01, 2021 12:58 PM by vj78
Mar 01, 2021 02:50 AM|vj78|LINK
I have two fields and they need to match.
I have a written a iif([field1]=[field2],1,0) but this is returning records even though they are same as '0'.
Mar 01, 2021 08:10 AM|Sean Fang|LINK
but this is returning records even though they are same as '0'.
Could you please specify the problem?
Is the function not working as expected?
Or do you select unmatched values using this IIF function but it returns the records which are matching?
It would be much helpful to target the problem if you could post more information.
Mar 01, 2021 12:58 PM|vj78|LINK
I also did NOT know until I pasted records in excel. I have a join to capture the field2.
when the match is done and I paste the records in the excel. It brings in all the 4 values for field2. Its supposed to bring only 1 where the match is.
So, the question now becomes different.
My join is not working properly to get the field2 get all values from the table in excel but in access it displays the that record perfectly ok.