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