Case Statement

[Lee Ann]

I am new at programing. I am trying write a module that
determines what the childs height and weight "Normals"
depending on their Age and Gender.

I have male coded as 0 and Female coded as 1

Say if a male at age 5 their weight should be 50 pounds
and height should be 36 inches

Thanks

Lee Ann

 

[John Vinson]

I am new at programing. I am trying write a module that
determines what the childs height and weight "Normals"
depending on their Age and Gender.

I have male coded as 0 and Female coded as 1

Say if a male at age 5 their weight should be 50 pounds
and height should be 36 inches

I'd suggest creating a Norms table with four fields - gender, age,
height and weight. This table can then be linked in a query to
retrieve the child's norms.