Results 1 to 4 of 4
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313

    Bar Graph on Form with Drill Down Capability

    My company has 9 Regions. Each Region consists of 3 to 9 Divisions, and each Division contains 3 to 9 Stores. I would like to display a Bar Graph on a Form to show the Sales in each of the 9 Regions and allow the operator to click on one of the Regions. When this happens, I would like to open another Bar Graph showing all the Divisions (3 to 9) within the selected Region. Then by clicking on a Division, I would like to show a final bar graph showing all the Stores (3 to 9) within the selected Division. Are there any Examples or Tutorials to help me do this?

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    https://www.youtube.com/watch?v=YhgNX6BWWmk

    I like this one.
    Develop your queries and charts first, then use the event procedures to customize the queries for those charts and show them.

  3. #3
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313
    The YouTube video was great. I added some command buttons to navigate to other graphs that "drill down" and the users love it. Thanks for the help, Eddie

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Glad to help. Success is bliss.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 24
    Last Post: 07-28-2015, 10:50 AM
  2. Drill Down capability
    By Eric@Gopher in forum Access
    Replies: 3
    Last Post: 08-07-2012, 01:01 PM
  3. Replies: 6
    Last Post: 02-29-2012, 03:13 AM
  4. Replies: 2
    Last Post: 02-13-2012, 02:41 PM
  5. Replies: 3
    Last Post: 01-10-2011, 10:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums