Query Expression Help

[Kim296]

I'm trying to create a formulated field that will display the record delivery status, so that I can filter the status for reporting. This formula appears to be working as I'm creating it in the expression builder; however, when I go to the datasheet view it shows "#error". Can anyone see what I am doing wrong? Any help is appreciated.


RStatus:
IIf([STATUS]="Approved" And (IsNull([PROVIDEDATE])),"Pending Delivery",
IIf([STATUS]="Denied","Denied",
IIf([PROVIDEDATE]>1,"Delivered","")))

 

[Kim296]

I solved this. I figured out that my "Approve" and "Denied" were referencing the ID number, so I had to substitute 1 and 2.

RStatus: IIf([STATUS]=1 And (IsNull([PROVIDEDATE])),"Pending Delivery",IIf([STATUS]=2,"Denied",IIf([PROVIDEDATE]>1,"Delivered","")))

Thank you!