This little demo file contains a number of custom age related functions, with examples of how each is called. If you have difficulty opening the link, copy the link (NB, not the link location) and paste it into your browser's address bar. Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to amend the form design accordingly. To take a look at Age.zip in my public databases folder at: It depends on the position of the birthday in the year in relation to the position of the current date in the year. The DateDiff function or simple subtraction will not always return the correct age on the basis of a persons date of birth.
0 Comments
Leave a Reply. |