Need Help with a parent/child report

[peciam]

Hello to all,

I have a parent table, main contract information. And then a child table for salary data for each year the main contract covers. A one to many.

I want to develop a report like this:

Clerk/Typist Salaries

County District 2005-06 2006-07 2007-08

Albany Albany City SD 11.50 12.24 12.70
Bethlehem SD 12.00 12.28 12.54


Any ideas? Should I use a report with a sub-report.

Thanks to all that reply. Any examples welcomed.

 

[SgtJarrow]

First, if you are building a report, you should use the report forum (forum703) to get more specific answers.

Second, you would not have to use a subreport in this case most likely, but it will depend somewhat on your data. Create a query that shows all the columns you want, then use the ReportWizard to build a report based off this query, and group it by county...

That should produce what you want.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer