CoffeeGuru
Registered User.
- Local time
- Today, 17:08
- Joined
- Jun 20, 2013
- Messages
- 121
I have a query and one of the fields currently contains alphnumerics:
4 units
5 units
8 units etc.
I want my query to just bring back the numbers 4, 5, 8 etc
the highest value is 60 units so in Excel I would have the option of using the formula:
Left(a1,2)*1
By multiplying the result by 1, would ensure the resulting value was numeric. How can Access do this?
4 units
5 units
8 units etc.
I want my query to just bring back the numbers 4, 5, 8 etc
the highest value is 60 units so in Excel I would have the option of using the formula:
Left(a1,2)*1
By multiplying the result by 1, would ensure the resulting value was numeric. How can Access do this?