Query Question

[Correy]

I have three tables I'm trying to query.

Table 1 - Employees
Table 2 - Cell Phones
Table 3 - Pagers

And what I'm trying to do is query ALL of the employees in Table 1 and show
either their pager number or cell phone number or still list them even if
both those fields are Null.

Can someone help point me in the right direction. Everytime I try to
run/create my own query I just get the employees that have both a cell and a
pager.
Any information would be greatly appreciated.

Thanks, Correy

 

[KARL DEWEY]

SELECT IIF([Cell Phones].[Number] Is Not Null, [Cell Phones].[Number],
[Pagers].[Number] AS Contact
FROM ([Employees] LEFT JOIN [Cell Phones] ON [Employees] .[ID] = [Cell
Phones].EmployeeID]) ([Employees] LEFT JOIN [Pagers] ON [Employees] .[ID] =
[Pagers].EmployeeID]) ;

 

[Correy]

Ahh...I think that might work.

Thanks!!

SELECT IIF([Cell Phones].[Number] Is Not Null, [Cell Phones].[Number],
[Pagers].[Number] AS Contact
FROM ([Employees] LEFT JOIN [Cell Phones] ON [Employees] .[ID] = [Cell
Phones].EmployeeID]) ([Employees] LEFT JOIN [Pagers] ON [Employees] .[ID]
=
[Pagers].EmployeeID]) ;


--
KARL DEWEY
Build a little - Test a little

I have three tables I'm trying to query.

Table 1 - Employees
Table 2 - Cell Phones
Table 3 - Pagers

And what I'm trying to do is query ALL of the employees in Table 1 and
show
either their pager number or cell phone number or still list them even if
both those fields are Null.

Can someone help point me in the right direction. Everytime I try to
run/create my own query I just get the employees that have both a cell
and a
pager.
Any information would be greatly appreciated.

Thanks, Correy