Age calculation help needed 1

[techexpressinc]

I have a DOB on the database.
Table = Members
Field = DOB

I seen this as a formula - “AgeCalcField: AgeInYears([DOBField], Date())” -


Within my query I do this
I click the field box
and coded an expression as listed here and get a syntax error:

“AgeCalcField: AgeInYears([MembersOB], Date())”


Can someone help in getting the age on my query working?

Thanks a lot - Russ @ scaninc.org

 

[techexpressinc]

I did not create the DB i just work with it. I think the join fields is a crazy thing from someone hooking up a drop down box a [MemberID#] field joined to [Recipient F Name].

I do not think that has anything to do with the DOB field not calculating the years old problem with the query.

If you like I will just bring in the one table with the DOB field to see if that problem can be resolved.

Thank you for taking the time of looking at the doc.

Russ

 

[dhookom]

You didn't answer my previous questions.

Duane
Hook'D on Access
MS Access MVP