Merge two columns

  • Thread starter Thread starter trans
  • Start date Start date
T

trans

I have two columns of data that each represent a Service Description. If
Column 1 has a Description, Column 2 will be blank and vice versa.

How would I create a 3rd column to merge this data together. So if in Row
1, Column 1 there is a Description, Column 3 will show this value. If in Row
2, Column 2 there is a Description, Column 3 will then show that value.

Thanks for the help.
 
I have two columns of data that each represent a Service Description. If
Column 1 has a Description, Column 2 will be blank and vice versa.

How would I create a 3rd column to merge this data together. So if in Row
1, Column 1 there is a Description, Column 3 will show this value. If in Row
2, Column 2 there is a Description, Column 3 will then show that value.

Thanks for the help.
Click to expand...

Well, you certainly should NOT have three fields in a Table with this kind of
interdependency - you shouldn't even have the first two!

You can use a calculated field in a Query to display whichever description is
non-Null by using the NZ() function:

ServiceDescription: NZ([Column 1], [Column 2])

will display the value in Column 1 if there is one, and if there isn't,
whatever is in Column 2. Of course they might BOTH be Null, or there might be
records where your constraint that one must be NULL is violated...
 
Back
Top