Hi,
I am struggle a bit with the following problem and any help would be gratefully received.
I am trying to separate different numbers from within one field. I have a field with the format:
1234567890
I will need to perform a calculation with each individual number but I don’t know how to separate them from each other (For example I will need to use the 5th number in a calculation without any of the other numbers). I have tried the left function but this will take all the values to the left of a point, I want the numbers individually. This will all be part of a function written in VBA using MS Access 2000.
Thank you for any help you can offer.
Phil
I am struggle a bit with the following problem and any help would be gratefully received.
I am trying to separate different numbers from within one field. I have a field with the format:
1234567890
I will need to perform a calculation with each individual number but I don’t know how to separate them from each other (For example I will need to use the 5th number in a calculation without any of the other numbers). I have tried the left function but this will take all the values to the left of a point, I want the numbers individually. This will all be part of a function written in VBA using MS Access 2000.
Thank you for any help you can offer.
Phil