I am working with a report based on a query with many interrelated tables. This query pulls data about individuals and their rotations through various departments, their pay status, etc.
One of the Report Headers is Departments. In addition to being related to the individual records, the Departments table is also related to another table that displays annual notes about the Departments. These notes are related to the department only, and not to any individual. How can I display these deparmental notes in my report if they are unrelated to the individual data?
Thanks for any help you can offer.
One of the Report Headers is Departments. In addition to being related to the individual records, the Departments table is also related to another table that displays annual notes about the Departments. These notes are related to the department only, and not to any individual. How can I display these deparmental notes in my report if they are unrelated to the individual data?
Thanks for any help you can offer.