Query not displaying all records

Teebird

Registered User.
Local time
Tomorrow, 05:31
Joined
Sep 3, 2006
Messages
60
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?
 
You might have better luck if you posted the SQL for the query.
 
Code attached

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

Many thanks
Tee.
 

Attachments

Change the Join to a Left Join instead of an Inner Join.
 
Ah how do I do that!

From the relationship field or in the query?
 
In the query. Right click on the joining line and look at Join Properties.
 
Excellent - works like a charm....
 

Users who are viewing this thread

Back
Top Bottom