Right now our company at Canada has many remote (small) sales offices all across the Europe, each office needs access to the internet. They are currently connecting to their local MSN ISP for the internet connection for work. Problems:
1. With no technical background on the sales and language...
I have tried to group the "Amount" expression together as one Text column using your suggestion, however because it is a text coulmn, the whole word is enclosed by the " ", like
10, 1, "4, 9 , 10, 15 ,6"
10, 2, "4, 2, 15 ,19 ,2"
11, 1, "3, 5 ...
Thanks for the quick reply..
Yes I need to get away those commas..
Can you please explain more on the part "concatenate all the expressions into a single expression"? Do you mean the expressions on the query itself?
thanks!!
Hi, Hope someone can help me with this. I have a table with data in following format:
250,25
251,25
252,25
253,25
254,25
that I want to add 2 new columns like following
250,25,1,4
251.25,5,4
252.25,9,4
253.25,13,4
254.25,17,4
where the value in the 3rd column is the sum of the values of 3rd and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.