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....