I have a report that is based on a query that uses a form field for the criteria. Like [Forms]![f_Danielle]![Customer] & "*" . I do this because if the selection field is left blank I want to get all the customers.
This works fine for most of my customers but doesnt work when i use a customer with a low digit number
For example, if I select a customer with customer number of 1 it will select all customers that start with 1.
If i choose customer 8 it will select all customers that start with 8
If i choose customer 9 it will select all customers that start with 9
If i choose customer 10 it selects all customers have 10 at the begining
So when a full customer number is chosen, like 11624, it works fine because there are no other customers with number 11624???
Is there a way to make it so that it still selects all customers when I leave it blank but will be more specific with the number chosen?