T
Terry
Michael,
Start by getting the query right. Add the 3 tables to your
query and join the tables by their common fields. Drag all
the field you want in your report onto the query. In the
criteria section under the Company field put something
like [Enter company name you want] and when the query runs
the user will be prompted to enter the company name.
Base your report on this query. Group by Company then by
student then by class (if you want students in each class
rather than classes for each student swap the student and
class grouping) Include a group header on the first two
groupings and put the company name field in the company
header and the student name in the student header and the
class name into the detail section.
HTH,
Terry
Start by getting the query right. Add the 3 tables to your
query and join the tables by their common fields. Drag all
the field you want in your report onto the query. In the
criteria section under the Company field put something
like [Enter company name you want] and when the query runs
the user will be prompted to enter the company name.
Base your report on this query. Group by Company then by
student then by class (if you want students in each class
rather than classes for each student swap the student and
class grouping) Include a group header on the first two
groupings and put the company name field in the company
header and the student name in the student header and the
class name into the detail section.
HTH,
Terry