How to append information to all data in a field?

's Computer Specifications

I have a field "SITE" that I need to append "2201" in the front of what is
already in the field. How can this be done using a query?

's Computer Specifications

If you want to do it to the whole table:
UPDATE myTable
SET SITE = "2201" & SITE

....but if you only want to do it to a single record, or a specific set of
records:
UPDATE myTable
SET SITE = "2201" & SITE
WHERE x = y

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"pokdbz" <(E-Mail Removed)> wrote in message
news:27A5E7CA-AED3-4D25-ABF9-(E-Mail Removed)...
>I have a field "SITE" that I need to append "2201" in the front of what is
> already in the field. How can this be done using a query?

's Computer Specifications

Great works perfect

"Graham R Seach" wrote:

> If you want to do it to the whole table:
> UPDATE myTable
> SET SITE = "2201" & SITE
>
> ....but if you only want to do it to a single record, or a specific set of
> records:
> UPDATE myTable
> SET SITE = "2201" & SITE
> WHERE x = y
>
> Regards,
> Graham R Seach
> Microsoft Access MVP
> Sydney, Australia
> ---------------------------
>
> "pokdbz" <(E-Mail Removed)> wrote in message
> news:27A5E7CA-AED3-4D25-ABF9-(E-Mail Removed)...
> >I have a field "SITE" that I need to append "2201" in the front of what is
> > already in the field. How can this be done using a query?
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: How to cut/append data from one field to another	Douglas J. Steele	Microsoft Access Forms	5	13th Dec 2006 05:06 PM
Append data to memo field	Abay	Microsoft Access Forms	2	22nd Jan 2006 09:40 PM
Append Data & Split Field into Three Fields	Barry McConomy	Microsoft Access	2	3rd Apr 2005 03:55 PM
How do I import and append data to a table that has a key field ?	=?Utf-8?B?Um94YW5uYQ==?=	Microsoft Access External Data	1	7th Jan 2005 06:30 PM
Append Data to Field	news@blueyonder.co.uk	Microsoft Access Database Table Design	5	17th Sep 2004 10:18 AM