Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Access query

Author  Topic 

mary_itohan
Posting Yak Master

191 Posts

Posted - 2005-12-02 : 07:08:30
hello,
i have this list of numbers in an excell worksheet

now i can import them to MS ACCESS, however i would want to convert them from 08 to 2348

what query coudl i use to achieve this ?

thanks
Mary

Yes O !

jhermiz

3564 Posts

Posted - 2005-12-02 : 10:19:51
more info please what the hell is 08 ???


Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-03 : 02:33:38
>> however i would want to convert them from 08 to 2348

Why and what logic do you want to follow?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-12-03 : 14:41:57
I think Mary means

converting all numbers thta start with 08 to 2348 ?

???
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2005-12-04 : 01:34:55
Mary, you have to provide us more info else we can only guess what you want and cannot provide a reasonable accurate advice or answer to your question.

Please refer to following link and help us to help you.
[url]http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx[/url]

thnkx

-----------------
[KH]
Go to Top of Page
   

- Advertisement -