I have a query which has a DateTerminated field (date format) and I would like to restrict the records to show all employees that are not terminated before a certain time.
Right now if I put "Is Null" in the criteria line, it gives all employees who are not terminated.
If I combine the criteria with < 01/01/2000, then I only get the records of the terminated employees after this date.
I need to show both. Should I first convert this date field to a number field and then use the greater than?
Any help would be appreciated as this query and its criteria will be used in a yearly scheduling form, so I need the criteria to always show the non-terminated or active employees for the base year.
Thank you.
Right now if I put "Is Null" in the criteria line, it gives all employees who are not terminated.
If I combine the criteria with < 01/01/2000, then I only get the records of the terminated employees after this date.
I need to show both. Should I first convert this date field to a number field and then use the greater than?
Any help would be appreciated as this query and its criteria will be used in a yearly scheduling form, so I need the criteria to always show the non-terminated or active employees for the base year.
Thank you.
