Records with no value

[nickysquawkes]

Hi - I have what maybe a relatively easy problem to solve.

I have a list of locations each with a unique id. I also have another table with location details in it. There is a relationship setup between the two tables. However in the first table I have some locations that do not have a match in the second table. Therefore that field is left blank. When create a query to show information from the two tables, any records that have a blank location match field do not get shown in the output. Is there anyway to display records with blank fields?

Thanks

Nick

 

[FoFa]

LEFT JOIN instead of INNER JOIN the two tables
Might need to adjust your crieria also

 

[Mile-O]

Sorry, Fofa, but nickysquawkes has wasted your time.

This is a double post and has been resolved here.

nickysqwakes, please don't post the same question more than once.