Access: Calculate age from date of birth - how it works

In Access, a formula can be used to calculate the age from the date of birth and thus save a lot of time. You can find out how this formula works in this guide.

Access: Create query for the date of birth

First of all you have to create a query for the age or date of birth so that the formula also works correctly in the end:

1. Go to the "Create" tab in Access and click on "Query Assistant".
2. In the next window, select the table in which the date of birth is saved.
3. In order to determine the later display, you have to determine the column headings below by marking the respective headings and clicking on the individual arrow. With a click on the double arrow, the headings are adopted.
4. Then enter a name for the query, for example "age query".
5. Click "Finish" to close the wizard.

Calculate age from birth date in Access

1. After you have closed the wizard, click on an empty column and enter the following formula: "= (DATE () - [field name of the date of birth]) / 365.65".
2. This calculates the date of birth. Replace the "Field name" variable with the actual field specification in which the date of birth is written, for example A1.
3. Finally, enter the "Run Query" command to run the command and see your age.