convert a string to a number

[nerdcore]

How would I convert a text field in a table to a number on a report or in a query? Because of specific reasons I cannot just change this field to a number field...however I would like to perform a calculation on it as a number, but can't find a function that will let me do this. The text field holds the size of scanned hard drives in bytes and i would like to divide it so I can display it in Gigabytes. Thanks!

 

[Darrylles]

Hi,

You'll need VBA to do it, use the VAL function which reads a textual string and returns a subset of numbers within that string.

mystr = "101 Highland street"
myval = val(mystr)

myval would hold "101"

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk