[ms_access] Remove characters from a string

[ian_stevenson200]

Hi,

I have a field (StudID) that has numbers but they are surrounded by quotes

e.g '123456' 

Is there a way in a query that I can remove these quotes so that i can return

123456

Thank for any help

Ian