copy last four digits of phone number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have multiple phone number columns in several tables of a single access
2002 db. I want to create an automated feature that will export (copy, send,
whatever name you prefer) the last four digits of a phone number to a new
column. I do not care if it is in the same table or a new one.

I have tried to think of a way to do it in a query but not I cannot figure
out the syntax to use for it.
 
Since you will be adding a column to your data, the best way would be to use
an update query to load the data into the new column. Hopefully, your
current phone number field is text. Let's say your current phone number
fields is [PHONE_NBR] and the new field is [LAST_FOUR]. In the Update To:
column of [LAST_FOUR]:
=Right([PHONE_NBR], 4)
 
Back
Top