Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Posts
    3

    Unanswered: Question about queries

    Im creating a database and im trying to create a query so i can create a mail merge, i wnat the query to bring up a list of any students whose qualification ends within 30 days,

    if anyones got any questions which i havent asked then just reply with your question and ill get back to you

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Try a criteria of this on the qualification date field:

    <(Date() + 30)
    Paul

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Or < DateAdd("d", 30, Date())
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jun 2008
    Posts
    3
    Ok thanks for replying, i should have mentioned that each of the students qualification ended last year between 16/03/07 and 21/05/07, would it be easier to just change the date for when the qualification ends, or is that too much trouble, ive got a backup so might give it a try

Posting Permissions

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