Selecting data from this year's month 1

[Chummly66]

I have this code which allows me to enter the month, and the query will give me the data I need. But, I found that since I have data from september 2005, it pulls from that september as well as the current september. The code is listed below... is there any way I can do this so only the current year's data is pulled, ignoring last year's "september"?

thanks in advance guys!!

PARAMETERS [Forms]![Workorders]![txtDateToRepair] Long;
TRANSFORM Count(Workorders.WorkOrderID) AS CountOfWorkOrderID
SELECT Workorders.cboManufacturer, Workorders.cboModels, Count(Workorders.WorkOrderID) AS [Total Of WorkOrderID]
FROM Workorders
WHERE (((Month([txtDateToRepair]))=[Forms]![Workorders]![txtDateToRepair]))
GROUP BY Workorders.cboManufacturer, Workorders.cboModels
PIVOT Workorders.cboCategory;

 

[Golom]

PARAMETERS [Forms]![Workorders]![txtDateToRepair] Long;
TRANSFORM Count(Workorders.WorkOrderID) AS CountOfWorkOrderID
SELECT Workorders.cboManufacturer, Workorders.cboModels, Count(Workorders.WorkOrderID) AS [Total Of WorkOrderID]
FROM Workorders
WHERE (((Month([txtDateToRepair]))=[Forms]![Workorders]![txtDateToRepair])) [red]AND Year([txtDateToRepair]) = Year(Date())[/red]
GROUP BY Workorders.cboManufacturer, Workorders.cboModels
PIVOT Workorders.cboCategory;

 

[Chummly66]

Thank you very much Golon!!

Richard

 

[Chummly66]

oops, Golom.. sorry about that