B
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))
),"mmdd"))
B
bgregory
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!
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!
Rick B said:DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))
R
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
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
bgregory said: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!
Rick B said:DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))