Quaries Multiple table + Null Problem

[syah96]

Hello
Here the thing, i got multiple table where it share one similar field which (1 to 1 relationship). All the table connect to staff profile table where sharing the staff ID. The table content different record. What i want to do is to make a query( or any other way) to display all records in all table through the staff ID. However the problem is some of the table may not contain some of staff record.
Can someone help me..

 

[Alansidman]

Change the join in your query from an Inner join to an outer join. Look here for an understanding of outer joins.

http://office.microsoft.com/en-us/a...n-outer-join-query-in-access-HA001034555.aspx

 

[syah96]

Tq. Will Try.

Edited: Tq Bro. You solve my problem