Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009

    Unanswered: Using <1year in a Search Form

    Hi all,

    I am trying to replicate this search form and I am having problem with the Year Registered Field. I am using Access 2007.

    Buy Used Car & Used Cars Singapore - sgCarMart

    Problem 1.

    How do I create a query which searches for cars which are registered less than a number of year(s) from the current date? I currently store my data in a Date format under a field called RegistrationDate.

    Problem 2.
    How do I create a dropbox which searches for either the year registered or < x year(s)? Im assuming that there are 2 queries: searching for the year registered is 1 query and the other query is < x year(s).

    Any help/suggestions on this would be well appreciated!

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    have a look at the dateadd function
    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