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
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