How can I calculate the age of a child based on birthdate?

[Guest]

 

[Rick B]

DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))

 

[Guest]

I guess that I need more help. Can you tell me where I need to enter this?
Does this need to be entered as a number? It has been years since I've
worked with Access and my memory isn't recalling a whole lot. Thanks!

DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))

 

[Rick B]

You would enter it in an unbound text box on your form or report.

You can also do it in a query by creating a new column and giving it a name,
a colon, then the formula. For example...

CurrentAge:
DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))


If you do that, then "CurrentAge" will be an available field in any form or
report that you build using this query as the data source.

--
Rick B

I guess that I need more help. Can you tell me where I need to enter this?
Does this need to be entered as a number? It has been years since I've
worked with Access and my memory isn't recalling a whole lot. Thanks!

DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))

 

[Joseph Meehan]

DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))



news:[email protected]...

You can enter it in a query (new column) or a report or form.