Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help With Grouping Sup-Reports

Status
Not open for further replies.

carlcwc

Technical User
Sep 3, 2002
43
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top