cunningham93
Registered User.
- Local time
- Today, 06:02
- Joined
- Mar 17, 2014
- Messages
- 13
I am hoping that someone can help me with my report. I have attached a PDF copy for review. Currently my report is grouped by Judge, then Treatment Center, then Treatment Type. and it does generally look at it should but does not indicate the values in an easy to understand way. I would like it be laid out as follows in columns:
Judge (number of clients assign) Treatment Center (number of clients assign), Treatment Type (number next of next to each treatment type), Sex (number of male, number of female) Drug of Choice "DOC" (number of next to each type of drug) Discharge Type (number of next to each type).
I have tried to rework my query and the report several time to make this happen with no success. Currently, my query gathers all of the clients who have a record on the inpatient treatment table, grouped by and with totals. I am open any and all suggestions. Thank you in advance for your assistance.
Judge (number of clients assign) Treatment Center (number of clients assign), Treatment Type (number next of next to each treatment type), Sex (number of male, number of female) Drug of Choice "DOC" (number of next to each type of drug) Discharge Type (number of next to each type).
I have tried to rework my query and the report several time to make this happen with no success. Currently, my query gathers all of the clients who have a record on the inpatient treatment table, grouped by and with totals. I am open any and all suggestions. Thank you in advance for your assistance.