Report from a Query

[cunningham93]

I'm having trouble creating getting my report to display the information I want from my query. My query has gathered all the information regarding my clients both their Inpatient Treatment and their Outpatient treatment. Which Treatment Centers they attended, type of treatment, discharge status type of drug being treated for, number of days in treatment, Education Level, etc... I'd like to organize this information first by treatment Centers and not by client. First, I would like to group the report by Treatment Center and how many clients at attended each one. Then I want to group the report by Treatment Type and how many for each, then group by discharge type and how many for each and then which drug treated for and how many for each. I have the query written and it is pulling the information needed. I just cant get it organized. Any help you could give me would be much appreciated.
Thank you in advance for your assistance.

 

[Isskint]

Grouping and sorting on a report are fairly straight forward - to do, not so easy to describe. Your easiest approach has to be using a report wizard. Once you have specified which fields you want to display, it will give you options to group by multiple fields and arrange the sorting order you want.

If that is giving you problems, can you post a copy of your DB (or a link) and i am sure someone will give you direction with some example reports.