Hi. I generated a list of over 1,200 birthdates, I.E. 4/9/2019 & put them into a database Table. From this table, I created a query containing the age & birthyear criteria. I’m not a person who likes to assume, however, I assume that the birth years as well as the ages increases as the calendar years changes. Let me give an example. The current year is 2019, the birthdate is 5/231992, which would make the year 1992, & the age would be 27. Therefore, (I assume) come next year, 2020 Access will automatically change the birth year to 1993, & the age will change from 27 to 28. Let’s supposed I’m right for a moment. My actual question is, if I wanted to make this query into a Table then the birth year & the age would not change every new year. At first, I was ready & wanted to make this query into a Table, but I stopped myself realizing how probably the birth years & ages will not increase every new year. I think I’m right, just looking for reassurance.
Any advice/suggestions would be greatly appreciated! Thanks in advance!