2nd Request for Help on Same Problem Please Respond

[carlcwc]

This is my second posting on this and I really need help on this one, if it can't be done, at least let me know..
I have a report that displays the demographics and services of my clients. Table1 holds the demographics and Table2 holds the services. The report generates the current information based on starting/ending dates. While I've been able to create individual sub-reports for the demographics (ie: income, age, etc.) The services is a field with many values. The sub-report breaks down the values (IE: number of outreach=3,number of advocacy=3, etc..)What I want is a breakdown of demographics for each service listed.
For example:
Outreach:3
Age(only from the 3 shown in outreach)
Income (only from the 3 shown in outreach)
I hope I'm making myself clear. I'm pretty much a newbie with some working knowledge of VBA and SQL
Thanks in advance

 

[pdldavis]

Hi, it sounds like all you really need to do is create a group header for for services and list your demographics under that - no vba coding required. You shouldn't need subreports either.

The two tables in your query should be joined to show all from services and only those in demographics that are equal.

Depress the sorting & grouping icon - [{= (looks sort of like that)

Sort on Services first and set group header to yes.
Place your Services control source in the header area.
Place your demographics control source in the detail section.

You could probably use the report wizard to accomplish the same thing and then modify the report design to suit your needs.

Hope that helps

 

[carlcwc]

Thanks for the tip, but I've tried that already, I get the same demographics for all the headers.

 

[KornGeek]

How are you joining the tables? If you're getting the same demographics for every service, it sounds to me like you have an error in the way you joined them.

 

[carlcwc]

I join the tables by the Primary Key-ClientID