Character string

[mghareeb]

Hello,

I know this is a basic question and I looked in the help file but can't get
the function to work ...

I have a 6 character numeric field but I want the query to return only the 5
right characters. For example:
Actual data: 012345
Needed data: 12345

How do I accomplish dropping off the first character?

Thanks.

 

[Jerry Whittle]

Mid([TheFieldName], 2)