How do I pull only two numbers from a six digit numeric field?

A

AccessIM

I have a table that includes a field called "Customer Number". In this field
are 6 digit customer numbers. I want to create a query that has a field
called "Division" that only pulls the first two digits of the 6 digit
customer number.

Is this possible?
 
Top