Showing first 5 numbers out of 8 from a field

[ivanteo]

i have a [field] which stores data made up of 8 digit numbers. i want to get only the first 5 digits from this number.
anybody? any help would be greatly appreciated!

 

[Geoff Codd]

should be something like this

= Left([FieldName],5)

 

[anna the third]

If you use VBA it is

= Left([FieldName],5)

If you use the expression builder

= Left([FieldName];5)

A little access annoyance!!!!

anna

 

[ivanteo]

Thank you so much!
it really was a big help!