report date query

[fadetoblack]

Hi, I would like to have a report linked to a query. I want the query made with a date field. When the report is opened I want to be asked a month and it shows me all the dates data within that month. Could anyone help me with this please. I also want the data to be from the current year when the date is selected.

thank you very much

 

[grnzbra]

SELECT *
FROM Table
WHERE Month(DateField) = [Month:] and Year(DateField) = Year(Now())