By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,255 Members | 2,773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,255 IT Pros & Developers. It's quick & easy.

How to use blanks as valid cells values in join

P: n/a
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?

Oct 17 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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?
Oct 17 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.