Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    3

    Unanswered: I am new to this so please answer if you can

    I have clients dob in the database ie 02/11/1957

    I want to be able to pick all the client with a year of birth before 1957


    In " query design view" I click on "or" then "Build" in the expression builder screen I type datepart("yyyy")<1957 but this does not work can you help with the correct format.

    Thankyou for reading this and helping

  2. #2
    Join Date
    May 2012
    Posts
    3

    sorted thanks

    sorted thanks

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ...and your solution was (so that others with the same problem could learn from your expereince
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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