|
Posted by Crumb on 02/23/06 02:46
Hi All,
Bit of a newbie question i'm afraid, so sorry if this is a really
stupid question,
I am not sure if I am trying to do this in the right place as I am sure
SQL Server has a far better way of doing this
What I am trying to do is join the contents of several columns and
present the entry into a new column. the entries of all the columns I
am trying to join are different types such as dates and numbers. I want
to join all columns as a text string. To make it just a even more
tricky I wish to insert a # between all fields.
Just in case my poor description has got you thinking What the F*&K
here is an example of what I am trying to do
C1 C2 C3 C4 C5
Ian 1234 22/02/2006 123456789 Ian#1234#22/02/2006#1234567890
I have been trying to do this in the Formula in the design veiw of the
table.
Any Advice would be fantastic.
Many Thank
Ian
Navigation:
[Reply to this message]
|