Directions to Resources

  • Thread starter Thread starter Padda-Juan
  • Start date Start date
P

Padda-Juan

Hello, recently completed New Horizons 4 day Access 2003 class. I have
inherited some data bases that the level of instruction did not cover. For
instance, a query is converting a text field from a table into what appears
to be a numeric by
![field]/1.
I have tried to research this online. I am guessing that this is a SQL topic.
Please point me in the direction of some resources to research this topic
and it's cousins.
 
Here's a list of the resources I find useful for Access:
http://allenbrowne.com/links.html

For your immediate question, performing a numeric operation (such as
multiplying by 1) would probably end up having the value treated as a
number, but will fail if the text field contains a non-numeric value. Val()
might be safer, but you will also need to handle nulls.

Of course, the best solution would be to create a Number field in the first
place rather than try to sort out the confusion caused by treating Text as
numeric.
 
Back
Top