waseem0888
Member
- Local time
- Today, 23:38
- Joined
- Jul 25, 2020
- Messages
- 51
I want to show the pie chart on the form like below image when i will select month from dropdown data for that month should show on pie chart and same for daily report when i select the date. I have status column in the table which having values like UR, A, B, C, D and i want to show on chart like UR is for under review and A for Approved, B for Approved with Comments, C for Revise and D for reject i just done through query to change all these form short code to full form but I never work in access charts don't know how to make query to get the data in chart i attached some as example in DB kindly some one help me how i can do this in access.