Access Can MS Access 2 (mostly) unrelated tables?

[ryan.debok]

I've created some tables with employee data. I'd like to be able to print a final report that is a summary of the data stored in the tables. However, the data in the tables is mostly unrelated.

Table 1: Audits Performed / Results
Table 2: Vacation Requests / Vacation Used

This is the simplest explanation... because in the future I may include more table data, but the employee will be the only common theme between the data (Work Performance, Customer Contacts, Roles / Responsibilities).

Let me know if this is possible.

Thanks,
Ryan

 

[alow]

It's probably possible. To get data together in the same record, you would need to first create a select query that pools the data based on a common field. Then, use the query as the source of a report to show the data in a neat summary. In order to get more in depth, I'd need to know more about the database. What fields do you want in the report and where are they in the tables? If you can figure it out, good luck!