Converting dates to age field

[MANDI201]

Help - silly problem I am sure easy for someone to solve but I am having trouble converting a date field into an age field not experienced enough to use VB managed to get query to show age by taking dob year away from current date but if person born tommorrow will still show same age as a person born yesterday! agghhh.

 

[pdx_man]

Check out the DateDiff function in Access Help:

DateDiff("yyyy",[DateOfBirth],Date()) or better yet,
DateDiff("m",[DateOfBirth],Date()) / 12