Emeregency: Medical DB Query Help

[jobux]

Need some help: I received an old dbase that has about 20 medical condition fields for about 500 patients. When a patient has a symptom/disease, the field is marked XX. Most patients have multiple symptoms, thus multiple fields marked XX. No symptoms are of course left blank. My question is this, how do I formulate a parameter query that will search ALL symptom fields & show the results in a form/ report by showing XX in the appropriate symptom box, & leave blank those that aren'tmarked? Many thanks for any help!.

 

[Ziggy1]

It sounds like you need to "normalize" the data, You say you have 20 fields for medical conditions, it would be better to have one field for all the conditions. In effect the symptom would be entered as a record, if a patient had 5 different symptoms you would have 5 records.

Then you could put in criteria like: Is not null to omit the blanks.

Go to tools/analyze/table.

It just sounds more like a spreadsheet, sorry if I misread it.

Ziggy