troubleshooting Question

Left Join SQL Access change blank field

Avatar of vishalarya
vishalaryaFlag for United States of America asked on
Microsoft AccessSQL
4 Comments1 Solution908 ViewsLast Modified:
When using an update query in Access, I'm doing a left join on two tables, so that those rows that match will be updated with fields from the 2nd table, while if the rows in the 1st table don't match, then the field will be blank.  However, I want this field, if blank, to default to something else, for example "N/A".  I outline a simple example:

Table 1:                        Table2:
row1  row2               row1           row2
1                                1                a
2                                2                b

If I LEFT JOIN Table 1 and Table 2 on row1, and set table1.row2 = table2.row2, I will get:

row1   row2
1         a
2         b
3        ""

I would like the 3rd position to not be blank, but some other text.  How can I do this?

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros