Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2011
    Posts
    2

    Question Unanswered: Need help with Microsoft Access queries can some one help

    I am just learning the query critera in Access and can't seem to figure out how to write a qury, I am trying to write a query that says how many has been enrolled for four years or more. I use eht builder but the return gave me a columb that says incorrect function. This is what I wrote, in a seperate columb from the First Name Last name and enrollement date i use builder to create a formula as seen below but I am not getting the result.

    Please help!!

    years: DateDiff("yy",Date(),[EnrollmentDate])>4

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    i don't have Access any more so i can only go from memory.
    ?? try "yyyy" instead of "yy"

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    izyrider's memory is correct! "yy" is not correct, it needs to be "yyyy"

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Jul 2011
    Posts
    2

    What am I doing wrong

    Its still not working

Posting Permissions

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