query dates

[kingsgambit]

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]

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.