Search results

  1. C

    the number of years left query

    Hello I have a submission date field and a no of years field. I want to create a query that returns a number of years but subtract the years that have already been: For example submission date = 28/11/2011 + no of years = 30, which works out to be 28/11/2041 but I also want the return to...
  2. C

    Query criteria to return < 2 years remaining

    Hello I am trying to create a parameter query to return dates that have 2 years remaining. For example I have dates for when mortgages expire, and I want to recognise the dates that have two years remaining using a parameter query but I can't figure out if I use DateAdd or DateDiff. Charlotte
  3. C

    Parameter query to return clients in particular age

    Hello I am using Access 2010. I've calculated the age of clients by creating a new field with Age: Year(Now())-Year([D O B]) but I cannot figure out how to use a parameter query to return the age of the clients between age 20 and 30, 30 and 40, 40 and 50 etc. Any tips? Charlotte
  4. C

    Hello

    Hi All My name is Charlotte. I am a regular user of access but struggle sometimes. I look forward to helping others and being helped. :)
Back
Top Bottom