Transfer values from one field to another field within the SAME table

How would I transfer the values from my WorkPhone field to my
CellPhone field within the same table IBCCP Referral?

Thanks!,

John

On Tue, 8 Jul 2008 07:14:50 -0700 (PDT), zufie wrote:

Quote:

How would I transfer the values from my WorkPhone field to my
CellPhone field within the same table IBCCP Referral?
>
Thanks!,
>
John

Run an update query.

Update [IBCCP Referral] Set [IBCCP Referral].[CellPhone] = [IBCCP
Referral].[WorkPhone];
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Back up your table first so if you make a mistake, you can try again. Run
this query:

UPDATE [IBCCP Referral]
SET CellPhone = WorkPhone;

Chris
Microsoft MVP

zufie wrote:

Quote:

>How would I transfer the values from my WorkPhone field to my
>CellPhone field within the same table IBCCP Referral?
>
>Thanks!,
>
>John

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200807/1

Transfer values from one field to another field within the SAME table

re: Transfer values from one field to another field within the SAME table

re: Transfer values from one field to another field within the SAME table

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about