Good Afternoon,
I am trying to get a "Textbox" to give a total if the "assigned to" = "M" and Status = "Pended" as per below.
=[Data]![Assigned To]="M" And [Data]![Status]="Pended"
I am getting an error as #Name?.
I am unsure of where i am going wrong or is there an easier way to do this?
Thanks
Gav
I am trying to get a "Textbox" to give a total if the "assigned to" = "M" and Status = "Pended" as per below.
=[Data]![Assigned To]="M" And [Data]![Status]="Pended"
I am getting an error as #Name?.
I am unsure of where i am going wrong or is there an easier way to do this?
Thanks
Gav