Search results

Many thanks for allowing me into your world of Access, I’m a newbie who has decided to re-learn Access as a hobby, having used it in it’s infancy, probably 40yrs ago now, in the age of reel-to-reel :) - I have just started a project to catalogue my records/CD collection, and am pulling in all...

I have a text field which number the records, and need to sort as if the numbers are actually numbers. If I sort now, I get 1,11,2,21, etc. because the values are text equivalents of numbers. Is there a function, as in Excel’s =Value(text) that I can use?