How to Enter Same Text in 1000s of Fields

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

Guest

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?
 
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";
 
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
 
Back
Top