Multiple conditions when building

[JustAccess]

I need help in correcting an expression. Can't seem to get the right combination of commas, etc. I need to verify if data exists in 2 fields that the data equals ;OR if no data exists in BOTH fields then that is also considered to be equal. If the data equals then it should return a "Y" otherwise "N" . If anyone knows how to correct this it would be greatly appreciated!

PROJ CODE: IIf(([Award Notification]![Special Project Code]=[By Call Number]![Proj Code]) Or IIf(AND(IsNull([Award Notification]![Special Project Code],IsNull([By Call Number]![Proj Code])),"Y","N")

[June7]

Try:

PROJ CODE: IIf(Nz([Award Notification]![Special Project Code],0)=Nz([By Call Number]![Proj Code],0), "Y", "N")

[JustAccess]

Try:

PROJ CODE: IIf(Nz([Award Notification]![Special Project Code],0)=Nz([By Call Number]![Proj Code],0), "Y", "N")

This works for the null piece but when I try to combine with the first part (where if there is data it verifies that they are equal) it bombs and states I have the wrong number of arguments. Is the "OR" part connecting it correctly?


PROJ CODE: IIf([Award Notification]![Special Project Code]=[By Call Number]![Proj Code] Or IIf(Nz([Award Notification]![Special Project Code],0)=Nz([By Call Number]![Proj Code],0), "Y", "N"))

[June7]

Don't need any OR part.

Just the expression as suggested should do what you want.

[JustAccess]

You are correct! Thank you so much, I would have never figured that out.