I am trying to run a parameter query with user input on a date field (out of service date) but i Dont need a specific date. I need to be prompted for
1. records with a date - 2. with no date - or 3. all records.
This will give me items that are out of service, inservice or both. Kind of like -Null or Not Null or All
I tried different expressions in the criteria field but with no luck .
I am working on a select query in the criteria field
All help is greatly appreciated
Thanks in advance Vacco