Returning All Values in a Query

[frankbutcher]

Hi.
Can someone help me?
I am trying to make a query return all values (please see attached jpg)
It returns some of the values, but is not returning values that have nothing in the "material" field (Null Values?)
In this example, I would like it to return all values that fulfill the Completion_Date, CW_Department, Handed_Over and Chargable fields, whether they have any data in the Material field or not.

Do I need to use the NZ, IIF or IsNull function? I have seen this is previous threads, but nothing like this example.....I apologise if there is.

Many Thanks.

Frank.

 

[aleb]

Change in SQL of your query the word INNER to Left.

You want to see every record from the table tblJobDetails and also records from tblMaterials if they present ( if I am not mistaken )

 

[frankbutcher]

Superb, thank you very much.

I take it, it is to do with SQL programming? Will have to take a look.

Once again, thanks.

Frank.