Chart on Report

[gjameson via AccessMonster.com]

I have a chart report set up and it works fine. I would like to modify it to
allow the month to be selected from the form. I have set up a combobox with 2
cols. 1 for the # and the other for the name to be displayed. (cboMonth) How
can I incorporate this into my query? The query below came from the wizard.


SELECT (Format([Date_of_Reading],"mmm"" '""yy")) AS Expr1, Sum(qryLedgerQuery.
Consumption) AS SumOfConsumption
FROM qryLedgerQuery
GROUP BY (Format([Date_of_Reading],"mmm"" '""yy"));

 

[gjameson via AccessMonster.com]

Got this to work by just using a form for my charts.

I have a chart report set up and it works fine. I would like to modify it to
allow the month to be selected from the form. I have set up a combobox with 2
cols. 1 for the # and the other for the name to be displayed. (cboMonth) How
can I incorporate this into my query? The query below came from the wizard.

SELECT (Format([Date_of_Reading],"mmm"" '""yy")) AS Expr1, Sum(qryLedgerQuery.
Consumption) AS SumOfConsumption
FROM qryLedgerQuery
GROUP BY (Format([Date_of_Reading],"mmm"" '""yy"));