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")