Data in report header from table unrelated to other data in report

Kila

Registered User.
Local time
Yesterday, 22:13
Joined
Mar 5, 2003
Messages
275
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.
 
Hello Kila!

I suppose you have got more departments.
If departments not related to individual data,
how do you know which department do you need ???
 

Users who are viewing this thread

Back
Top Bottom