Query not displaying all records

[Teebird]

Hi All

I have 28 records in my table - when I run the query (made by using the wizard) it only picks up 6 records.

I have no criteria in the query - just a straight query fulling all fields from the table.


Any suggestions?

 

[RuralGuy]

You might have better luck if you posted the SQL for the query.

 

[Teebird]

Code attached

Here is the SQL...
And my relationships....

Many thanks
Tee.

 

[RuralGuy]

Change the Join to a Left Join instead of an Inner Join.

 

[Teebird]

Ah how do I do that!

From the relationship field or in the query?

 

[RuralGuy]

In the query. Right click on the joining line and look at Join Properties.

 

[Teebird]

Excellent - works like a charm....

 

[RuralGuy]

Glad I could help.