Makeing a text field act as a number field ???
Posted on 2005-05-13
I have a field in my DB that gets imported from a *.csv file.
This field is considered a text field but I would prefer it act as a number field.
This field is called "Living_Area" and it has a number of records that look like this:
Because it contains "sqft." it acts like a text field, how can I create a custom field or somthing similar that will make this field act as if it is a number field?
The reson I need it to act like a number field is becuase I will be exporting this from Access into a special excel file that allows you to search number fields using <,>,<=,>=...
and I want to have that capability w/ this field w/out having to get rid of "sqft."