null or is not null

[jer]

Is there a way to pick up blanks in a query. I am trying
to create an inventory of applications (Resource inventory
details) being used by staff. I am attempting to create a
query (the basis for a report) that will show what
applications are being used and not being used by every
staff member. The queries I have attempted so far only
shows what applications are being used but not those not
being used, e.g. a staff member may use 5 and not use 5, I
want the query to list all applications and show those in
use and those not in use. Is there a way to show both.
thanks in advance for any suggestions advice
jer


SELECT [Employee Details].EmployeeName, [Employee
Details].JobFunction, [System Details].System, [Resource
Inventory Details].LogInId, IIf([Resource Details]!
[ResourceId]=6,"Functional Id","") AS FunctionalId
FROM [Employee Details] RIGHT JOIN ((([Resource Inventory
Details] INNER JOIN [System Details] ON [Resource
Inventory Details].SystemId = [System Details].SystemId)
INNER JOIN Enviromnent ON [Resource Inventory
Details].EnvironmentId = Enviromnent.EnvironmentId) INNER
JOIN [Resource Details] ON [System Details].ResourceId =
[Resource Details].ResourceId) ON [Employee
Details].EmployeeId = [Resource Inventory
Details].EmployeeId;

 

[[MVP] S.Clark]

To show ALL records from one table, you do an outer join. Typically, if
it's a parent, then it's a LEFT Join, and if it's a child, then a RIGHT
join. I see that you have a RIGHT join, so maybe you're just pointed in the
wrong direction. Trying turning it around and see what happens.