Results 1 to 3 of 3
  1. #1
    Join Date
    May 2008
    Posts
    48

    Unanswered: Filter records on Date & Time

    I have a table in MS Access which contains following fields :

    Date of Production Short date like 10-Apr-09
    Job Begin Time 24 Hours time like 07:00
    Job End Time 24 Hours time like 19:25

    Now, I want to filter only those records where Job begin time starts 7:00 AM of a particular date (say through Form) and ends 7:00 AM of next date. Say 7:00 AM of 10th Apri'l09 and 07:00 AM of 11th April'09.

    I shall be thankful if anybody enlighten me how to make query for the above.

    Thanks

    Sanjay Mathur
    (sanjaylml)

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Now the above row would not satisfy this. You don't have an end date recorded apart from anything.

    Do you mean rows where the start and end times fall BETWEEN the dates and times you specify?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    May 2008
    Posts
    48
    Exactly I want to filter only those records which fall between date & time, I specified.

Posting Permissions

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