ablettablet
New member
- Local time
- Today, 18:09
- Joined
- Jan 5, 2012
- Messages
- 9
Hello All
Firstly I'm using Access 2013 DESKTOP version for this database.
I've created a database that everyone in our company uses. I need to be able to run some sales reports including a breakdown of sales for the month by business area, this needs to display in the form of a pie chart. I've created the query which pulls together the order date, category and sales value. I've also managed to create a form which contains a pie chart showing the total to date breakdown of sales. To the form I added StartDate and EndDate text boxes which pick up the information from a request form (this opens up this form and a report which shows a line by line entry of each order, this works fine). I've added the code in VBA and as I mention the report works fine but I'm really struggling to get the form to filter by these. Please help! I'm sure there is a way of doing it but I've not found it.
If it helps I can add a sample to work on.
Thanks everso, any assistance is really appreciated!
V
Firstly I'm using Access 2013 DESKTOP version for this database.
I've created a database that everyone in our company uses. I need to be able to run some sales reports including a breakdown of sales for the month by business area, this needs to display in the form of a pie chart. I've created the query which pulls together the order date, category and sales value. I've also managed to create a form which contains a pie chart showing the total to date breakdown of sales. To the form I added StartDate and EndDate text boxes which pick up the information from a request form (this opens up this form and a report which shows a line by line entry of each order, this works fine). I've added the code in VBA and as I mention the report works fine but I'm really struggling to get the form to filter by these. Please help! I'm sure there is a way of doing it but I've not found it.
If it helps I can add a sample to work on.
Thanks everso, any assistance is really appreciated!
V
