[qwertyqwerty]

Hi there.... I'm a bit of a newbie to Access and you probably all know how to do this no problem but here it is:

I have a table with a field containing various codes. I have a second table with the description of these codes. I can join the two tables easily but whenever the (first table) code field is empty, the joined table does not show those entries. I have tried to get around this by adding a blank field to the second table but the joined table still kicks out the blanks.

How can I join the tables without losing the blank entries?

Thanks... I hope that makes enough sense....

M

[Advertisements]

M,
You won't be able to join on a (blank) null value.

Lets assume
table A contains codes; 11 22 33 44 55 and
table B contains codes; 11 33 44 only

then a query with an equal join will only show records for 11, 33 and 44

however if you modify the join properties to "include all records from table A and only those records from table B where the joined fields are equal"
Then you will get the result you are looking for.


HTH
David

[dsm]

M,
You won't be able to join on a (blank) null value.

Lets assume
table A contains codes; 11 22 33 44 55 and
table B contains codes; 11 33 44 only

then a query with an equal join will only show records for 11, 33 and 44

however if you modify the join properties to "include all records from table A and only those records from table B where the joined fields are equal"
Then you will get the result you are looking for.


HTH
David