Convert varchar to number field

2001-04-20 Thread Martin E. Koss
Hi, I started a table with a varchar filed of 11 characters for a column that would hold data such as 0.27; 11; 0.6; 1; 5; 7.5; 11.2; etc I wasn't sure if a 'number' field would work. Now I want to list the values in this column and they do not list numerically, for example: if we had 0.27; 0.6; 1

myODBC from Access to mySQL (Failing)

2001-05-09 Thread Martin E. Koss
I'm still pulling my hair out. If anyone knows of a place on the web where I can read about the changes that have to be made to Access 97/2K and/or Win95/98 that could also really help. Any help will save my hair. Thanks. Martin E. Koss M: 07946-706459 E: [E

RE: myODBC from Access to mySQL (Failing)

2001-05-09 Thread Martin E. Koss
alling 2.50.37 Thanks to everyone who tried to help. Martin. -Original Message- From: Bruce Stewart [mailto:[EMAIL PROTECTED]] Sent: 09 May 2001 12:43 To: 'Martin E. Koss' Subject: RE: myODBC from Access to mySQL (Failing) Hi Martin, I'm fairly new to MySQL, have had simi