Queries not showing all records

[Guest]

Hello
I have a query made up of several fields from a few tables. TBL Scheme is my
main table, it holds all my clients. TBL Fee Basis lists their fee basis,
however, There is not a record for every single client since I don't have the
fee info for some of them. When I include these two fields in a query, The
query returns only those clients who appear on the TBL Fee Basis. I want it
to show ALL those on TBL Scheme and just show nothing in the Fee Basis column
if there is no entry there.

The relationship I have created is option 2 ie show ALL records from TBL
Scheme regardless of whther they are equal in TBL Fee Basis. However as I
have described my query does not behave like this. Can anybody help??!!

Thanks
Ian

 

[Allen Browne]

Open the query in design view.
Double-click the line joining the 2 tables, and check that it is actually
option 2 and not option 1.

If you switch the query to SQL View (View menu), you should see LEFT JOIN or
RIGHT JOIN, not INNER JOIN.

 

[Guest]

Thanks Allen,
When I double clicked the lines they definitely said option 2. Yet when I
opened SQL it said 'INNER JOIN'. Not to worry, I altered the SQL statement
manually and it now works fine
thanks again!!