Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Convert a String to a Number
Awesome! The "Val()" function works! Don't know why I couldn't find it - guess I was too stuck on looking for a way of doing a conversion. Thanks so much!- COLTAB
- Post #5
- Forum: Microsoft: Access Tables and Relationships
-
Convert a String to a Number
OK - should have included this in the original post... To convert the fraction to decimal I have used the following statement...- COLTAB
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Convert a String to a Number
I have been struggling with this problem for a few days so I'm hoping someone can help. I have a field which is designed as a string and contains sizes such as 1/4" , 1/2" , 3/4" , 1 1/2" etc... I need to convert these to a numeric field where I can select the largest size within a group of...- COLTAB
- Thread
- Replies: 5
- Forum: Microsoft: Access Tables and Relationships
