How to Enter Same Text in 1000s of Fields

L

lbohen

I have a an Access 2003 db of 11,000+ records. Each record has a field named
Product Type. The field is now blank and I would like to enter the phrase
audio books into each field. Can I do this with a query? How?
 
D

Duane Hookom

You could use an update query with a SQL view like:

UPDATE [an Access 2003 db of 11,000+ records]
SET [Product Type]="audio books";
 
M

MH

If you want to update every row, regardless of any current data:

UPDATE MyTable
SET ProductType = "Audio Books"

If you only want to update the rows where the ProductType column is NULL
use:

UPDATE MyTable
SET ProductType = "Audio Books"
WHERE ProductType IS NULL

MH
 
Top