View Full Version : query dates


kingsgambit
12-19-2001, 09:23 AM
I am trying to attach a query to a report so the report will show all the holidays taken by staff for the current year.
I need the query to show the records from 31st December last year to 31st December this year.
I can not find a way to put the month of december in a query with the current year, the the query to pick up all the records in the parameter

Rich
12-19-2001, 09:39 AM
Easiest way is to put Between [StartDate] And [EndDate] in the criteria grid of your date field and see if that produces the correct results.