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.
IIf([STATUS]="Approved" And (IsNull([PROVIDEDATE])),"Pending Delivery",
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.