As a beginner I need to create a stacked bar chart based upon a date parameter. I can create the chart without the date parmeter as follows:

TRANSFORM Sum([Extnd]) AS [SumOfExtnd] SELECT (Format([ScrapTicketDate],"DDDDD")) FROM [qryScrapTest] GROUP BY (Int([ScrapTicketDate])),(Format([ScrapTicketDate],"DDDDD")) PIVOT [LineCodeID];

How can I incorporate an action similar to what I have below:

WHERE (((tblScrapTicket.ScrapTicketDate) BETWEEN
[FORMS]![frmIndividualReports]![txtStartDate] AND
GROUP BY tblScrapTicket.ScrapTicketDate;