Case Statement

  • Thread starter Thread starter Lee Ann
  • Start date Start date
L

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
 
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
Click to expand...

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.
 
Back
Top