Hello,
I don't even know if this is possible since I am working with a date field but thought I would ask. To avoid having null values in my tables I have a default value populated in a date field (1/1/1900). there is a related text field (VRAprobation) and it is a yes/no/"N/A" field. basically what I need to do is if the date field is 1/1/1900 I want it to show on the report as either "N/A" or just blank. I have tried the following IIF statements:
IIf([VRAprobationStartDate]=1/1/1900,”N/A”,[VRAprobationStartDate])
IIf([VRAprobation]="N/A",”N/A”,[VRAprobationStartDate])
IIf([VRAprobation]="N/A",Null,[VRAprobationStartDate])
IIf([VRAprobation]="N/A",Is Null,[VRAprobationStartDate])
IIf([VRAprobation]="N/A",””,[VRAprobationStartDate])