Option buttons to create scale.

[davidjearly]

Hi,

I am attempting to create a database that can score patients based on symptoms. Each assessment criteria is scaled from 1 to 10 (10 being most severe).

There are 25 different assessment criteria that each have this scale. I would like to create a form whereby it is possible to enter a new assessment score for each criteria. The form would need to have fields for entering the patient's name, dob, assessment number (these assessments are carried out 4 times per year), and clinician.

Any tips would be very appreciated.

 

[davidjearly]

Anyone? If it can't be done the way I described, any other examples of how I could implement a scoring scale (1 - 10) in an Access form would be appreciated.

 

[jsv2002]

Is there any calculation done with the resulting scales? If not you could create the tables for Patient, symptoms, etc then have a main form (Patient) with another form (assesment) to enter details which could be populated with the patients details when opened from the main form. You could also have a subform and/or listbox in the patient form showing assessment history.

If calculations are required a similar method could be used but further detail would be required.

Regards John