referencing Queries

[June7]

Do these two records pertain to different patients? Where is the patientID?

You are using expressions to 'pivot' the data - like a CROSSTAB? So you need a count expression for each of the 4 symptom options? And the same for other questions - a count expression for each possible answer?

Aside from the difficulty you are having with this data analysis, consider what happens if you have to add a new question or a new answer option. Everything will have to be edited - table, query, form, report.



This is a nightmare! I think really need to normalize data, either in table structure or by UNION query for reporting requirements.

[Sheba]

each record refers to a different patient. for this scenario the recordID will be the patientID. And Yes, I'll need a count expression for each of the three options. I can't count the fourth option because user will use his own words - could be a word or a sentence. hence we want to see a list of what is in that column irrespective of who the patient is.

[Sheba]

hi I used a subreport for the [Other] field...