question

bass219 avatar image
bass219 asked

If null/none then return value in different column(same row)

i am working with two columns. in one column (placement ward) there are some blanks. When there are blanks i want to pull the values in another column (all committs), when it is not blank i want to keep the value in placement ward column. I am working in Access.Also the values are i am suppose to be working on are "none" not null. Not sure if that makes a difference.

nulliif
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.