Thank you Joan - your time is appreciated
SELECT Addresses.SalaryNumber AS Addresses_SalaryNumber,
Addresses.FirstName
AS Addresses_FirstName, Addresses.Surname, Addresses.DateOfBirth AS
Addresses_DateOfBirth, Addresses.StatusLookup, Addresses.DateOfHire,
Addresses.Status, Addresses.Workplace, Addresses.Position,
Addresses.SupervisorManager, Addresses.Address AS Addresses_Address,
Addresses.Town, Addresses.PC, Addresses.State, Addresses.Phone AS
Addresses_Phone, Kids.ID, Kids.Name AS Kids_Name, Kids.DateOfBirth AS
Kids_DateOfBirth, Kids.Gender, Kids.SalaryNumber AS Kids_SalaryNumber,
Medical.[Salary Number] AS [Medical_Salary Number], Medical.[Medical
Information], [NEXT OF KIN CONTACT 1].NAME AS [NEXT OF KIN CONTACT
1_NAME],
[NEXT OF KIN CONTACT 1].SalaryNumber AS [NEXT OF KIN CONTACT
1_SalaryNumber],
[NEXT OF KIN CONTACT 1].ADDRESS AS [NEXT OF KIN CONTACT 1_ADDRESS], [NEXT
OF
KIN CONTACT 1].PHONE AS [NEXT OF KIN CONTACT 1_PHONE], [NEXT OF KIN
CONTACT
1].MOBILE AS [NEXT OF KIN CONTACT 1_MOBILE], [NEXT OF KIN CONTACT 1].WORK
AS
[NEXT OF KIN CONTACT 1_WORK], [NEXT OF KIN CONTACT 1].[WORK PHONE] AS
[NEXT
OF KIN CONTACT 1_WORK PHONE], [NEXT OF KIN CONTACT 1].COMMENT AS [NEXT OF
KIN
CONTACT 1_COMMENT], [NEXT OF KIN CONTACT 1].[salary number] AS [NEXT OF
KIN
CONTACT 1_salary number], [NEXT OF KIN CONTACT 2].NAME AS [NEXT OF KIN
CONTACT 2_NAME], [NEXT OF KIN CONTACT 2].NewSalaryNumber, [NEXT OF KIN
CONTACT 2].ADDRESS AS [NEXT OF KIN CONTACT 2_ADDRESS], [NEXT OF KIN
CONTACT
2].PHONE AS [NEXT OF KIN CONTACT 2_PHONE], [NEXT OF KIN CONTACT 2].MOBILE
AS
[NEXT OF KIN CONTACT 2_MOBILE], [NEXT OF KIN CONTACT 2].WORK AS [NEXT OF
KIN
CONTACT 2_WORK], [NEXT OF KIN CONTACT 2].[WORK PHONE] AS [NEXT OF KIN
CONTACT
2_WORK PHONE], [NEXT OF KIN CONTACT 2].COMMENT AS [NEXT OF KIN CONTACT
2_COMMENT], [NEXT OF KIN CONTACT 2].SalaryNumber AS [NEXT OF KIN CONTACT
2_SalaryNumber], Partners.SalaryNumber AS Partners_SalaryNumber,
Partners.FirstName AS Partners_FirstName, Partners.RSVP
FROM ((((Addresses INNER JOIN Medical ON Addresses.SalaryNumber =
Medical.[Salary Number]) INNER JOIN [NEXT OF KIN CONTACT 2] ON
Addresses.SalaryNumber = [NEXT OF KIN CONTACT 2].SalaryNumber) INNER JOIN
Partners ON Addresses.SalaryNumber = Partners.SalaryNumber) INNER JOIN
[NEXT
OF KIN CONTACT 1] ON Addresses.SalaryNumber = [NEXT OF KIN CONTACT
1].[salary
number]) INNER JOIN Kids ON Addresses.SalaryNumber = Kids.SalaryNumber;
Joan Wild said:
Is it possible that you are that 'other user' - do you have the table
open
in design view? As for the other error message, that is unrelated,
however
post the SQL statement for it (open the query in design view, hit View,
SQL
and copy/paste that statement in reply.
--
Joan Wild
Microsoft Access MVP
Can someone help with Access messages please. The Query Wizard cannot
view a
new query in datasheet view "possibly because another user has a source
table
open in exclusive mode", which I don't think is the case. (After
closing
the
query, attempt to reopen causes another error message "type mismatch in
expression".)