View Full Version : Data in report header from table unrelated to other data in report


Kila
03-01-2006, 02:34 PM
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.

MStef
03-07-2006, 03:14 AM
I suppose you have got more departments.
If departments not related to individual data,
how do you know which department do you need ???