Query to show review dates from multi tables

[Archie1]

H I have the following tables:- Employees, Supervisors, Line Managers, Dept Managers. The tables store Appraisal information amongst other things. I want a query to extract Appraisal review dates from all the tables so I can then print it in a report to easily see who is due a review. I have tried a select query but cant get it to work as in it is duplicating Appraisal numbers. Whats the best way to do this? Thanks in advance

 

[plog]

The best way to do this is to set up your tables properly. You are effectively storing Position Type (employee, supervisor, etc.) in the table name. You don't do that. You store attributes of an object as values in a field. You don't have a new table for every last name do you (tblSmith, tblJones, etc.)? No, you have a field called [LastName] where you store the value of everyones last name ('Smith', 'Jones', etc.)

So instead of 4 tables, this data should be in just one table which would contain a new field called [PositionType] and in that field you would hold values like 'Employee', 'Supervisor', etc. That way all your [AppraisalReviewDates] are in one spot and what you want is a simple query.

 

[Archie1]

Ahh ok I will have a re-think then

 

[jdraw]

See this free data model for ideas.