armstrong722
Technical User
Hello!
I have a table that I added a field to and I would like to fill it with ages. There is a birthday field in the same table. So what I was wondering was whether I could make a query and pull the new field in [players_age] and using expression builder and a function for age populate the field with the players age.
My syntax is the following
Field: Players_Age
Criteria =Age(birthday,todaysdate)
I have the function allready built and it works.
but I can't seem to find the correct syntax.
Is this possible?
thanks from
a very new access user
armstrong
I have a table that I added a field to and I would like to fill it with ages. There is a birthday field in the same table. So what I was wondering was whether I could make a query and pull the new field in [players_age] and using expression builder and a function for age populate the field with the players age.
My syntax is the following
Field: Players_Age
Criteria =Age(birthday,todaysdate)
I have the function allready built and it works.
but I can't seem to find the correct syntax.
Is this possible?
thanks from
a very new access user
armstrong