Querying Access database while converting data

Hi everybody,

I have a Access database that is full of data like 01Ta05. Where Ta means 30, so the value of this is = 31.05. What I want to ask is if it is possible to build a VBA macro or a query that would recalculate that string to is numerical value and than search for other related data. Has anybody some experience with this?

Thank you,
Shuter

If all of your data follows the same scheme, then yes, it would'nt be too hard.