Hi, I'm not that great with Access but would like to ask for some advice.

I have 3 tables all linked with an ID number (one to many)

I create a query which I want to display the notes field from each of the 3 tables for each personID..

The problem is that say in one of the tables the person hasn't got any notes attached in a certain table then that user will not be displayed in the query results even though they may have other notes in the other tables.

I basically want to display every single user regardless if they have notes in each table or not.

Hi -

Please post your query SQL.

Bob

I think its something to do with left joining (Whatever that is)... I will put up the SQL statement when i have a chance.

Think this can be fixed in the relationships area might be wrong!