Extracting numbers from a field

[Sara Overton]

I am trying to produce automated printed cheques which require each unit of money to be listed in a separate box. The field it comes from is a calculated field.

ie £120 the 0 goes in 1 box, 2 in another and so on.

I have a formatted number field which is 7 numbers long. So all number are of the same length.

I've tried Left Trim etc. But nothing seems to be returned in the unbound fields I have set up.

Any ideas how to do this?

 

[aziz rasul]

Sara not sure whether this will help.


If FieldValue is the field that contains £120 and Field1 (on a form) should contain the 0, Field2 should contain the 2, etc in the Control Source property for

Field1 type =Mid([FieldValue],Len([FieldValue]),1),
Field2 type =Mid([FieldValue],Len([FieldValue])-1,1),
Field3 type =Mid([FieldValue],Len([FieldValue])-2,1), etc.


Aziz

[This message has been edited by aziz rasul (edited 05-30-2001).]