On 31 Jul 2006 11:54:35 -0700,
cincy_benn@yahoo.com wrote:
If you need different fields based on the project category, then yes a
subreport (one for each cat) is the simplest solution.
Yes, each subreport draws its data from its own query.
-Tom.
Quote:
>I need to create a report with information about active projects in my
>company. There are 4 categories of projects.
>
>About 80% of the info I need on my report is the same for all projects,
>20% differs by project category.
>
>I need a combined report for all of the projects that will group the
>projects together by category and then alter the headers (for the 20%
>difference) depending on what project type it is printing.
>
>Is subprojects the best way to do this? Do I have to run queries up
>front to separate the data to use a a source for each subproject?
>
>I am new to access and don't want to waste time on a poor design.
>
>Thanks,
>Ben
