Filling every record in a table with the same data.

[david.isaacks]

I currently have a table and one of my columns is Feature 1. I have
over 4000 records and I want to have this column to all have SD in the
field. Is their a way to auto populate all this data? With out having
to enter it into all 4000 records?

[Mark Reed]

UPDATE YourTable SET YourTable.[Feature 1] = "SD";

<da***********@mail.va.gov> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
I currently have a table and one of my columns is Feature 1. I have
over 4000 records and I want to have this column to all have SD in the
field. Is their a way to auto populate all this data? With out having
to enter it into all 4000 records?

[Cyberwolf]

Run an update query to change the field to SD

[david.isaacks]

Thank you, I tried the update query once, but it did not work. I just
try ited again and it worked.

David

[PC Datasheet]

You probably found this out but SD is a string and consequently where your
update query said Update To, you need to put the string in quotes:
"SD"
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com
<da***********@mail.va.gov> wrote in message
news:11*********************@u72g2000cwu.googlegro ups.com...

Thank you, I tried the update query once, but it did not work. I just
try ited again and it worked.

David

[StopThisAdvertising]

"PC Datasheet" <No****@Spam.Com> wrote in message
news:cH****************@newsread2.news.pas.earthli nk.net...

To Steve:
No-one wants your advertising/job hunting here!
Over 875 !! users from the newsgroups have visited the website to read what
kind of a 'resource' you are... (rapidly increasing..)

To the original poster:
Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell
his services.
And he is known here as a shameless liar with no ethics at all.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

[John Marshall, MVP]

This is a pointless post, Mark Reed already showed how to do it with quotes.
Did you not read that the OP got it to work?

John... Visio MVP

"PC Datasheet" <No****@Spam.Com> wrote in message
news:cH****************@newsread2.news.pas.earthli nk.net...

You probably found this out but SD is a string and consequently where your
update query said Update To, you need to put the string in quotes:
"SD" <da***********@mail.va.gov> wrote in message
news:11*********************@u72g2000cwu.googlegro ups.com...

Thank you, I tried the update query once, but it did not work. I just
try ited again and it worked.

David

[Randy Harris]

* John Marshall, MVP:

This is a pointless post, Mark Reed already showed how to do it with quotes.
Did you not read that the OP got it to work?

The post wasn't pointless. The point was not, however, to help the OP.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.