im trying to merge data from 20 columns into one column with "and" or a comma as a separator. unfortunately, i keep on getting the null values as well.
ex. column 1 - null
column 2 - null
column 3 - gate
merge into one column it looks like - "and and gate" or ", , gate"
how can i make access return the value only if it is not null - for twenty columns, i do not think it is practical to create if statements for all the possibilities. please help!!!!!