Mansoor Ahmad
Registered User.
- Local time
- Today, 00:47
- Joined
- Jan 20, 2003
- Messages
- 140
Dear All
I am not very good in creating charts in MS Access. I want to create charts on a report or form wherever suitable based on a parameter query. I have set two parameters, which are also defined in parameter dialogue box, one on Customer field and other on Analysis date field. On date field I have set parameter for range of dates ‘Between [Analysis date from] And [To]’. When query is run and prompts for Customer, I put ‘*’ to get all customers for that date range. So I get data for various customers.
Question is how I can create charts for each customer separately on same report based on one parameter query?
I am not very good in creating charts in MS Access. I want to create charts on a report or form wherever suitable based on a parameter query. I have set two parameters, which are also defined in parameter dialogue box, one on Customer field and other on Analysis date field. On date field I have set parameter for range of dates ‘Between [Analysis date from] And [To]’. When query is run and prompts for Customer, I put ‘*’ to get all customers for that date range. So I get data for various customers.
Question is how I can create charts for each customer separately on same report based on one parameter query?
