Left Join issues

[Annette]

I have an equipment table and an activity table. The activity table
shows the many locations and installation dates of the equipment. So a
piece of equipment could have been installed in many different
locations on many different dates. Also, some equipment may not have
an activity yet as it has not been installed.

I would like to create a query that shows all equipment, listing the
last date/location of equipment that has activity (been installed) in
addition to the equipment that hasn't been installed yet.

I first created a query showing all latest status of equipment and
then linked that to the equipment table and the activity table (using
left joins), but when I add the department table my query error's out
as the equipment that does not have an activity, certainly will not
have a department.

Any help on how to get the output I would like?

 

[John W. Vinson]

I have an equipment table and an activity table. The activity table
shows the many locations and installation dates of the equipment. So a
piece of equipment could have been installed in many different
locations on many different dates. Also, some equipment may not have
an activity yet as it has not been installed.

I would like to create a query that shows all equipment, listing the
last date/location of equipment that has activity (been installed) in
addition to the equipment that hasn't been installed yet.

I first created a query showing all latest status of equipment and
then linked that to the equipment table and the activity table (using
left joins), but when I add the department table my query error's out
as the equipment that does not have an activity, certainly will not
have a department.

Any help on how to get the output I would like?

Correct the error in the query.

For help doing so, please post the error message and the SQL of the query. We
can't fix a problem we can't see! What are the relationships between these
tables?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com