how can I write a quary to pull vacation dates between certain dates.
In the query I have these fields
Employee Name
Title
Department
Manager
Exec Manager
Requested Date (these are date fields)
From (these are date fields)
To(these are date fields)
Approved
I tried this to no avail
[OrdersAfterDate]![OrderDate]