I am writing a query that breaks down a report by customer. The customer field (Text0 on the form) is in a form so the user can select a customer and bring up the data in the query for that customer. I am trying to write a IIF statement in the query that if the customer (Text0 is the field on the form) is blank or null then it will show all the customers. Doesn't want to work for me:
Any help is appreciated.