Results 1 to 2 of 2
  1. #1
    Magnus1982 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2017
    Posts
    29

    Chart - Change dates grouping from Month's to Weeks

    Hello everyone,

    I working some time with access but I am not very experience user. I create some form with 6 Charts . Data fro this charts is coming from query . When I was using MS Access Chart Wizzard I select grouped by months. I am wonder is it any way to change this to weeks dynamicly.



    Some combo box on the form with option to choose Weeks or Months ?

    I tried link Chart query (this one which is in chart option) with combo box as I am doing e.q in criteria but is not working

    Please give some help

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Have to change chart RowSource SQL. Is chart on form or report? This will not be simple for report because this is a design edit. Use QueryDefs VBA to modify a query object that is used as RowSource. Then open report for viewing. Alternative is to build two charts and code behind report controls visibility.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Grouping weeks within years
    By BDibz in forum Queries
    Replies: 10
    Last Post: 04-06-2018, 03:21 PM
  2. Replies: 1
    Last Post: 08-09-2017, 02:49 PM
  3. Replies: 12
    Last Post: 04-16-2014, 07:26 AM
  4. Total Weeks and Concatenate Period Dates
    By mabuhay87 in forum Queries
    Replies: 4
    Last Post: 02-09-2014, 07:29 PM
  5. Search by weeks and or months (dates)
    By sdc1234 in forum Access
    Replies: 3
    Last Post: 08-30-2013, 10:57 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