I am using Crystal 8.5 with an Access 2000 database.
We have medical software that calculates BMI values and saves them into an Access Database. This field is stored as a String value ( that is updated with each patient). I need to take that string value, place into a variable and covert that to a number (actually a number range array).
Once my value is a number, then I have do calculations on the value to display different text for each patient.
What is the best way to convert a stringvar to a numbervar?
Here is an example of what I am trying to accomplish:
If BMI <18.5 then display “See your primary care provider now about your weight”
If BMI =18.5 <25 then display” Your BMI is within the normal range”
If BMI =25 <30 then display “Utilize resources for information regarding you weight.
Does anyone know of the easiest way to do this conversion and then calculates based on those values?
Any help I appreciate!!
We have medical software that calculates BMI values and saves them into an Access Database. This field is stored as a String value ( that is updated with each patient). I need to take that string value, place into a variable and covert that to a number (actually a number range array).
Once my value is a number, then I have do calculations on the value to display different text for each patient.
What is the best way to convert a stringvar to a numbervar?
Here is an example of what I am trying to accomplish:
If BMI <18.5 then display “See your primary care provider now about your weight”
If BMI =18.5 <25 then display” Your BMI is within the normal range”
If BMI =25 <30 then display “Utilize resources for information regarding you weight.
Does anyone know of the easiest way to do this conversion and then calculates based on those values?
Any help I appreciate!!