Conversion Problem - Text to Exponential
On Mon, 7 Dec 2009 14:50:51 -0800 (PST), Commish
wrote:
Sometimes Access is trying a bit too hard.
I am assuming this is a Text column. You may still want to force the
issue with:
select CStr(myField) from myTable
-Tom.
Microsoft Access MVP
I know that the Subject might be a little off, but here's my issue.
I am importing data from a spreadsheet into an Access database. In
this particular column of data, the data looks like this: 911B00,
91FT20, 911000, 91E000.
My issue is that when I import that column if data, for some reason it
takes the records with a "E" (like 911E00) and displays them as
exponential numbers and displays "9.10E+01" - how can I prevent Access
from doing that - or what function can a put in a query to fix that?
|