Report criteria

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

In my report header, I have the following code to return
the Cust_ID that I have selected in the frmCustDA. If I
leave the Cust_ID blank, it will return all records. How
could I show in my report header if Cust_ID is null, then
say "All Customers"? The below give me #name? as a results.

=iff(([Forms]![frmCustDA]![Cust_ID]) Is Null,"ALL
CUSTOMERS",([Forms]![frmCustDA]![Cust_ID]))

Could someone help me with this statement?

Thanks
Ashley
 
The function is IIf() not iff(). I would suggest:
=Nz([Forms]![frmCustDA]![Cust_ID],"ALL CUSTOMERS")
 
Back
Top