Hello All!
I've never experienced this issue and it is driving me nuts. I'm not super experienced in Access, but thought this was a pretty easy iif statement. I have a query based on a table that has a column called Calculated Card Expiration:
IIf([Card Type Issued]="PIV",[Issue Date]+1095,IIf([Card Type Issued]="Non-PIV",[Issue Date]+1095,IIf([Card Type Issued]="Flash",[Issue Date]+365,Null)))
It worked fine when I ran the query the first time, but now when a Card Type Issued and Issue Date is added or changed it doesn't work.
Thank you so much for anyone that can assist with what I'm doing wrong!
I've never experienced this issue and it is driving me nuts. I'm not super experienced in Access, but thought this was a pretty easy iif statement. I have a query based on a table that has a column called Calculated Card Expiration:
IIf([Card Type Issued]="PIV",[Issue Date]+1095,IIf([Card Type Issued]="Non-PIV",[Issue Date]+1095,IIf([Card Type Issued]="Flash",[Issue Date]+365,Null)))
It worked fine when I ran the query the first time, but now when a Card Type Issued and Issue Date is added or changed it doesn't work.

Thank you so much for anyone that can assist with what I'm doing wrong!