chart report based on months

[knzass]

i have created a chart report which is based on months(jan,feb,etc)
what i want to do now is to create a form where a user can choose to pick from what month to what month does he want to view the chart report
if possible, i want to put two combo boxes that will display the months of the year(January,February,Mac,etc)and a command button that will open the report..
so the user has only to choose from the combo box on which months he wants to see
-- ive created the report based on a query which has a field named "Date_Today" which uses the short date format (mm/dd/yy)

 

[Chris RR]

Create a query that will pick up the beginning and ending month parameters from your form & select all of the data that should be on the chart. Then base the chart on that query.