ivanteo
04-01-2002, 11:06 PM
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!
anybody? any help would be greatly appreciated!
|
View Full Version : Showing first 5 numbers out of 8 from a field ivanteo 04-01-2002, 11:06 PM 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 04-01-2002, 11:50 PM should be something like this = Left([FieldName],5) anna the third 04-02-2002, 01:20 AM If you use VBA it is = Left([FieldName],5) If you use the expression builder = Left([FieldName];5) A little access annoyance!!!! anna ivanteo 04-09-2002, 06:24 PM Thank you so much! it really was a big help! http://www.access-programmers.co.uk/ubb/smile.gif |