qryWHR sql as follow:
SELECT tblTest_BodyComp1.AssessmentID, tblTest_BodyComp1.TestDate, tblClientDetails.ClientID, [waist]/[hip] AS WHR, IIf([Gender]="Male",IIf([WHR]<0.9,"Ideal (Low Risk)",IIf([WHR] Between 0.9 And 1,"Moderate Risk",IIf([WHR]>1,"High Risk","Error"))),IIf([WHR]<0.8,"Ideal...