Access question

[WitchyRed]

How do I go about converting a date of birth field to age??

[vcant]

since my my computer doesnt work, and im on the other one i can not test it and give you the exact answer, but it should go somethig like that:

select (now-bdate) as age.....

[WitchyRed]

where would I enter that?

[vcant]

ok, let say you making a new query

then you put it like this:

select (now - bdatecolumn) as myage

from mytable

[WitchyRed]

Thank You!