text to numerics

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Is there a way to make access recognize text as a number, like in excel. I
have a column that has both numbers and text and when I change the format
from text to number it either deletes the record completly or just shows a 0
or null value. any ideas if this is possible??
 
No. Excel is an array of individual cells which have no relationship to one
another. Access (and all databases) has fields (columns) which have
attributes, one of which is the datatype. Other than a physical resemblance
a datasheet and a spreadsheet have nothing in common.
 
On Fri, 1 May 2009 06:04:15 -0700, Adam

Access is not Excel. In Excel you can have a column with a variety of
data types. In Access you cannot, so you have to choose what single
data type you want. If you want to preserve all your data, Text may be
the best choice.
You can convert such text using expressions like:
select Val(myTextField) from myTable
or
select CLng(myTextField) * myNumericField from myTable

-Tom.
Microsoft Access MVP
 
Back
Top