How to use blanks as valid cells values in join

[jason.teen]

Hi,

I'm having trouble using the blank/empty cells as valid values in a
join.

I have noticed that MS Access doesn't allow you to join with a blank.

for eg.

Des | val
------------
A | 1
B | 2
C |
D |
E | 4

Des | Val
---------------
A | 1
B | 2
C |

If I joined those two on both Des/Val combinations, only A | 1 and B |
2 will display and it will not consider the blank value as a valid
input.

How can I go around this?

[lesperancer]

blank / empty cells are probably NULLS, so you can create a query for
each table below, ie
SELECT des, nz(val, -1) from tbl1
and
SELECT des, nz(val, -1) from tbl2

then use the 2 queries in your 'join' query

ja********@gmail.com wrote:

Hi,

I'm having trouble using the blank/empty cells as valid values in a
join.

I have noticed that MS Access doesn't allow you to join with a blank.

for eg.

Des | val
------------
A | 1
B | 2
C |
D |
E | 4

Des | Val
---------------
A | 1
B | 2
C |

If I joined those two on both Des/Val combinations, only A | 1 and B |
2 will display and it will not consider the blank value as a valid
input.

How can I go around this?