Results 1 to 2 of 2
  1. #1
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286

    SELECT only this DATE RANGE (Pic Attached)

    Hello, I only want my query to select this date range. In the pic attached, The first column is the ID column. The value for the ID should be the same for the whole picture. Ignore the "count of date" column. What im interested in is selecting the proper values in the "DATE" column.



    The way it works is there should be 24 hour intervals for every day of the month, per ID.

    However, I want the query to check STARTING from 1 AM all the way through the first hour of the next day. So in this picture, instead of selecting 24 hours of 5/1, i want it to only select 23 hours of 5/1 and one row of the first hour of the following day, so in this case it would be 5/2 (the row that is highlighted). It should ignore the first 5/1 at the top of the picture.

    The reason is because in this example, "5/2/2012" is actually representing the midnight hour which is 00:00 but out machine converts it to the following day instead.

    so again, query should spit out
    5/1/2012 1:00:00 AM through 5/2/2012 and stop before 5/2/2012 1:00:00 AM


    THANKS SO MUCH

  2. #2
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286
    Click image for larger version. 

Name:	error.JPG 
Views:	10 
Size:	105.5 KB 
ID:	7856
    this is the image that was supposed to be attached

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

Similar Threads

  1. select range class issue
    By TheShabz in forum Programming
    Replies: 3
    Last Post: 03-20-2012, 07:37 PM
  2. Date Range Report with Multiple Date Fields
    By StevenCV in forum Reports
    Replies: 13
    Last Post: 02-29-2012, 08:29 AM
  3. Replies: 2
    Last Post: 09-18-2011, 03:45 AM
  4. Date not Sorting Correctly (screenshot attached)
    By KrenzyRyan in forum Queries
    Replies: 5
    Last Post: 06-27-2011, 01:44 PM
  5. Excel Automation Select Range Only with Data
    By orcinus in forum Programming
    Replies: 3
    Last Post: 02-09-2011, 01:03 PM

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