Results 1 to 3 of 3
  1. #1
    MFS is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Ohio
    Posts
    235

    Graph is not showing full two hours worth of requested data

    I hope this is an easy one . . . .

    My graphs are not showing the full amount of time that I am requesting in my queries criteria.
    In other words I've asked to show data from lets say 8:00am to 10:00am. The graph shows 8:00am to 9:45am.
    What could be causing this????

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    If your query pulls all data from this limit...then you have no record at exactly 10am. (945 is your last datum)

    To show a 10am that isnt there, you need an 'empty' record. Modify your query to add the min rec (8am) and max record (10am).
    I use a union query, 1 query has the max/min records, and union with 1 query with my real data.
    That way the entire range is given in the data.

  3. #3
    MFS is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Ohio
    Posts
    235
    That's the thing, I do have data for 10:00 am.
    I write my query criteria in textboxes on a form, in this case . . .
    Beginning time = 8:00am (Text100)
    End Time = 10:00am (Text101)
    I then hit an 'ENTER" command button which populates a form with a graph and a subform.
    The subform shows all the data from 8:00-10:00 but the graph only shows from 8:00 to 9:45.
    The 9:45 time is not always off by 15 minutes, the graph may on some occasions only be off by 4 minutes.

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

Similar Threads

  1. Replies: 3
    Last Post: 01-24-2013, 02:08 PM
  2. Replies: 4
    Last Post: 01-18-2013, 02:41 PM
  3. Replies: 1
    Last Post: 09-25-2012, 03:58 AM
  4. Showing Graph of Prior Days Downtime
    By MFS in forum Forms
    Replies: 4
    Last Post: 03-28-2012, 05:11 AM
  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