A query containing two fields, [CertificationExpiration] and [LifeTimeCertification] where only one of the fields will contain data and the other will be blank. In a query I am attempting to create a field called CertDate: which will contain the content of which ever field is populated. I am using the following statement. I get the false value but cannot get the true value.
CertDate: IIf([LifeTimeCertification]=Null,[CertificationExpiration],[LifeTimeCertification])
I have turn the statement around and interigated the CertificationExpiration field and get the same results, no value when true.
What am I overlooking
Thanks