Removing characters from the beginning of a text field.

[JackD]

Hi folks,
I would like to be able to delete the serial number from the beginning of a record (see below) but keep the rest of the information that appears after it. I have tried TRIM but that only seems to work with blank spaces. All the serial numbers are the same number of digits long (eight) and appear in the same place for every record.

00000782 D&E - Reg Serv, LA - J McDonald Some Place 08/10/04


Thanks for any input and thoughts,

Jack

 

[raskew]

Try the mid() function.

x = trim(mid([myfield], 9))

HTH - Bob

 

[JackD]

Bob,

Thank you for your kind help,

it worked a treat.

Regards,

Jack

 

[raskew]

Great!

Love it when a plan comes together.

Best Wishes - Bob

 

[MSAccessRookie]

Great!

Love it when a plan comes together.

Best Wishes - Bob

You tell 'em Hannibal!