I have a table that contains information on hundreds of families. Part of that data are the ages of each child of each family. The table contains columns for different age groups..... Ages 0-12, 13-18, 19-24 that I need to populate. Is there a query expression that will determine the age group a child belongs and show in the appropriate group field in the table?
The table contains some of the following columns:
Family Child 1 Age Child 2 Age Child 3 Age Child 4 Age Child 5 Age Ages 0-12 Ages 13-18 Ages 19-24 Smith 3 6 Jones
I am an experienced Access user but not a great programmer. I was attempting to write the following expression but not sure if this is the way to go.
Expr1: IIf([Child 1 Age]>0 and <13,"SET [Ages 0-12]"=???. The expression needs to be able to calculate if one or more children of each family fall in the same age group and record the total (for Smith above, I need to record 2 in the Ages 0-12 group)
F.Y.I, I have a query that will calculate the child's age based on the DOB and the System date to make sure the ages are always correct.
I appreciate any responses.