Access 2007
I got a split form. Basically, upper part contains buttons and the lower part is a table (from a query the form is based on). The table can be filtered (by clicking next to the column title, default access function) and I want to create a button that opens a graph/chart based on the filtered data on the first form. The chart would be a line chart.
The fields that matter are Name, Date, Time, Info1, Info2.
The user will first filter the table using Name field, Info1, Info2 or a combination of them or no filter. He might filter based on Time too if he doesn't want too old records.
He would then click a button to get a line chart. The chart shows the number of rows, based on Date. For example
Forgive me my horrible quickly drawn example. The user should also be able to select, if he wants to replace "Year" with a month or three months or six months. If I really have to, I could just create seperate forms/charts for that because there aren't that many options.
Does anyone have any helpful tips or links? Last time I tried to do something with Access forms, I couldn't get anything to work. And those charts were even simpler than this one.
I got a split form. Basically, upper part contains buttons and the lower part is a table (from a query the form is based on). The table can be filtered (by clicking next to the column title, default access function) and I want to create a button that opens a graph/chart based on the filtered data on the first form. The chart would be a line chart.
The fields that matter are Name, Date, Time, Info1, Info2.
The user will first filter the table using Name field, Info1, Info2 or a combination of them or no filter. He might filter based on Time too if he doesn't want too old records.
He would then click a button to get a line chart. The chart shows the number of rows, based on Date. For example
Forgive me my horrible quickly drawn example. The user should also be able to select, if he wants to replace "Year" with a month or three months or six months. If I really have to, I could just create seperate forms/charts for that because there aren't that many options.
Does anyone have any helpful tips or links? Last time I tried to do something with Access forms, I couldn't get anything to work. And those charts were even simpler than this one.
