Extracting Characters from a field

I have a field in my contacts database named 'HomePhone' which is my contacts home phone number. I am trying to extract the first three characters (area code) from the field and place it in another field named 'AreaCode'.
Is there someone who could guide me through this?

Thanks for the help.

Jan

Use Left function to return a string containing a specified number of characters from the left side of a string.


Example:

Left("This is my string", 3) 'will return "Thi"

Create an update query like this:

update tblCustomer set AreaCode=Left(HomePhone,3)