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.