Design based on Query Result

P

Peter

We are developing an Property Management System and there
is a linked table between Property & Employee.

The linked tables is
PropertyEmployeeID - Autonumber
PropertyID - Linked to Property Table
OwnerID - Linked to Employee Table
ControllerID - Linked to Employee Table

The OwnerID and ControllerID field can be empty. Usually,
the OwnerID field has value but the ControllerID is
optional.

I have tried the following query but are not able to get
the Employee Name unless both OwnerID and Controller field
are not null.

SELECT Employees.[FirstName] & " " & Employees.[LastName]
AS Owner, Employees_1.[FirstName] & " " & Employees_1.
[LastName] AS Controller
FROM Employees AS Employees_1, Employees, [Property
Employee] WHERE ((([Property Employee].OwnerID)=
[Employees].[EmployeeID]) AND (([Property
Employee].MaintaqnceID)=[Employees_1].[EmployeeID]));

Thank you for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot retrieve all records 13
Combo box won't update many side subform records 1
Employee's Form Problem 1
Training Record Database 6
Using Combo Box Selection to Query a Table 3
Data from from field not found in table 1
Automatically populate a field based on 2 others 9
Normalizing Tables and Enter Data in Fields Based on Employee Numb 1

Top