Results 1 to 6 of 6
  1. #1
    aaronjk99 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    3

    Age in .... months.

    I want to create a query where, in the criteria, it searches for who is going to be a certain age (in this case 17) in however many months (in this case 5 months). I need it to be close to real-time, doesn't have to run when the system is off, but say every time the database is opened. So that it stays up-to date. Any help would be much appreciated.



    Thanks.

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Not sure what you want.

    Do you want to know
    - how many months until the next birthday?
    - what their age will be in y months?
    - they will be x age in y months??

    You do have their birthday???

  3. #3
    aaronjk99 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    3
    The last of the three choices is what I want. So I have my database with all my records, I have their DoBs and their age, what I want to do is make a query that can tell me who will be 17 in the next 5 months.
    Thanks.

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    So if there are two birthdays, 4/10/2000 and 10/15/2000, what do you want to see?

    4/10/2000 was 17, 1 month ago? (birthday passed)

    10/15/2000 will be 17 in 5 months? (birthday coming up)

  5. #5
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Maybe something like this?
    Attached Files Attached Files
    Last edited by ssanfu; 05-25-2017 at 07:28 PM. Reason: changed zip file

  6. #6
    aaronjk99 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    3
    The later, I'd like to see the birthday coming up.
    Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. DateDiff for Months
    By Delta729 in forum Queries
    Replies: 4
    Last Post: 03-11-2015, 07:01 PM
  2. Only want the last 6 months rotating
    By Thompyt in forum Programming
    Replies: 4
    Last Post: 11-16-2014, 03:31 PM
  3. How to print From and to Months
    By talktime in forum Reports
    Replies: 2
    Last Post: 09-18-2014, 08:12 PM
  4. Replies: 3
    Last Post: 02-23-2014, 02:06 PM
  5. A months query
    By Peljo in forum Access
    Replies: 1
    Last Post: 02-18-2008, 09:07 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums