Hi all,
Please forgive me if this is really easy, but I'm from a 4G
background, and not too familar with pure SQL statements.
What I am trying to do is quite simple.
I have two text fields in a record, which I wish to merge at point o
extraction. Ie:
SELECT item-no, desc1, desc2 FROM mytable WHERE mytable.item-no
"MyItem"
To merge the description fields I have tried (for instance):
SELECT desc1 + desc2
But Microsoft Query expects the values as number data.
So I tried:
SELECT desc1 & desc2
and various other permutations, but still have no luck.
Can anyone point me in the right direction please?
Thanks in advance.
El
--
Message posted from
http://www.ExcelForum.com