Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2014
    Posts
    9

    Unanswered: Rolling 4 month chart in Access

    Hi,

    I am simple qry that displays the last 4 months of data....... Is there a way to display the last 4 months of rolling data? Can this be displayed as a dynamic chart in Access?

    Thx
    Attached Thumbnails Attached Thumbnails Rolling.JPG  

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    yes
    The chart after all is formatted at run time, based on the data provided to it, so assuming your query moves with the times then the actual chart will reflect that
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2014
    Posts
    9
    Quote Originally Posted by healdem View Post
    yes
    The chart after all is formatted at run time, based on the data provided to it, so assuming your query moves with the times then the actual chart will reflect that
    Can you guide me on how to do that in access?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    create your query
    create your chart
    ...jobsagoodun

    do I have time to walk you through the process... No
    do I have time to help with questions and or tweaking... probably
    will I (re)create your db scheme and data... No
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Feb 2014
    Posts
    9
    Quote Originally Posted by healdem View Post
    create your query
    create your chart
    ...jobsagoodun

    do I have time to walk you through the process... No
    do I have time to help with questions and or tweaking... probably
    will I (re)create your db scheme and data... No

    WOW..... Someone is having a bad day.

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Hardly. Ill help, i wont "do"
    I dont have the time to try and replicate your schema no do I have time to then add the data.

    If you feel you need 'better' assistance then feel free to pay for it elsewhere. I steal time from my working day to be here. The more time it takes to asdist here the less likely i can or will be able to do so.

    So make an effort, try and see if you cando it yourself and learn from the pro ess
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    For queries that return rolling periods relative to the present, look into the DateAdd function.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •