- 1). Open Access 2010 and click the "File" tab. Click "Open." Browse the files and locate the database. Click the database and the "Open" button. The database opens.
- 2). Locate a query containing the employee's birth date in the Navigation Pane. Right-click the query. Select "Design View." The query is displayed in the design view.
- 3). Add the following expression in the next available column field "=(Now()-[Birthdate])\365." Review the results by clicking the red "!" button. Notice the age in the new field.
SHARE
