Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    Can Jose, CA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query criteria to show records entered in last 2 h (Access 2k)

    Looking for query criteria string to show records created in last 2 hours. Table has a field that is auto-populated with date and time as records are entered

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query criteria to show records entered in last 2 h (Access 2k)

    you could use :
    >DateAdd("h",-2,now())
    as criteria
    Francois

Posting Permissions

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