Blank Fields

[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

 

[Mile-O]

First off, if you have a table for locations then why are the details relevant to the locations held in another table?

Unless a single location contains many records of details I see little reason to have two tables.

 

[nickysquawkes]

The other table holds details of that location. But it needs to be held in a separate sheet because the location details are linked to an Excel spreadsheet, which is updated on a regular basis

 

[Brianwarnock]

Seems a strange way to do things, but I think the answer to your question is to check your Join, it looks like your selecting only for matched records.

Brian

 

[nickysquawkes]

Thanks Brian. That has sorted it. There is method to the madness believe it or not