Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Posts
    2

    Red face Unanswered: Date/Time Query Problem

    I need to filter records where time < 8:15 from a table of records spanning up to a year. A criteria statement using #8:15 AM# returns nothing. A criteria statement using #4/5/2002 8:15 AM# works for only the one day. Does anybody have a solution? I am using Access97 and can't find any thing in the Help files.

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Function TimeValue(time) returns time part of datetime value:

    Try "Where TimeValue(MyField) < #8:15 AM#"

    Igor

  3. #3
    Join Date
    Apr 2002
    Posts
    2
    That works, Thanks very much

Posting Permissions

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