adding date criteria to an existing query in SQL

[zeusspandex]

Hi,

i have the following SQL query and would like to add date criteria to it. the field being [Date] from the table [Tonnage] and the criteria being

Between [Forms]![Recycling Rates]![From Date] And [Forms]![Recycling Rates]![To Date]

query:
SELECT [TCode],
Sum(IIf([Recycling],[Tonnage],0)) AS RecycTonnage,
Sum([Tonnage]) AS TotTonnage,
(100*[RecycTonnage]/[TotTonnage]) AS RecycPC

FROM [tblTonnage]

GROUP BY [TCode]

ORDER BY (100*Sum(IIf([Recycling],[Tonnage],0))/Sum([Tonnage])) DESC

[zeusspandex]

any attempt i make brings up and error message saying the quey is too complicated etc, try simplyfying it or adding parts to variables.