Age Distribution based on Birthdate field

[Guest]

I have one table that has field "Birthdate"

I have another table with two fields
Age of Retiree and Distribution Factor.

I need to find the Distribution Factor based against the Birthdate and the
Age field.

In long terms I need the database to look at the Birthdate fieled and check
against the Age field to come up with the Distribution Factor. How would I go
about this?

 

[John Vinson]

I have one table that has field "Birthdate"

I have another table with two fields
Age of Retiree and Distribution Factor.

I need to find the Distribution Factor based against the Birthdate and the
Age field.

In long terms I need the database to look at the Birthdate fieled and check
against the Age field to come up with the Distribution Factor. How would I go
about this?

My guess is that you would use an expression like

Age: DateDiff("yyyy", [Birthdate], Date()) - IIF(Format([Birthdate],
"mmdd") > Format(Date(), "mmdd"), 1, 0)

in a Query, and link it some how to the [Age of Retiree] field. If
said age field has one entry for each valid age, you should be able to
join this query to the distribution factor table.

John W. Vinson[MVP]