Remove Random Characters

[Butter]

I'm new to this so here goes...I've got an Access query that I'm trying to remove the first 5 characters from the 10 character name in each record. The name is composed of both letters and numbers. The first 5 characters vary but it is always the first 5 that need to go.

Thanks in advance!

 

[SRAB]

do a search for LTRIM

 

[RuralGuy]

Look in VBA help for the Mid() and Right() functions.

 

[Butter]

Thanks! The function...Right([fieldname],5)...did exactly what I needed. Thanks for pointing in the right direction.

 

[RuralGuy]

That's excellent and you are welcome. Mid([FieldName],6) would have worked as well regardless of the length of the string in [FieldName].