I'm having an issue with a criteria in a query. What I'm trying to do is have criteria as below:
1. Creation Date is Between Dates - Set to prompt user for a value.
2. Third Party Company is Not NULL.
3. Third Party Company 2 is Not NULL
The advanced criteria is set to 1 AND (2 OR 3)
This works perfectly as long as the Creation Date is a defined value and not set to "Prompt User". If it's set to prompt user the results that are given are the same as if I removed the brackets, 1 AND 2 OR 3.
Does anyone know if this is a bug in 7.3 or if there is something I am doing wrong? I would expect to be able to prompt users to enter the values as 9 out of 10 queries we use require a User-Defined Creation Date and this one needs the same.