In access, how do I paste a phrase into every cell of a column?

T

Theresa

I created a field and most of the cells in that column will have the same
info. After I've added all my entries, how do I paste a phrase or word into
every cell of that column?
 
D

Douglas J. Steele

Just a gentle correction. Access doesn't have cells: that's a concept from
Excel. Access has fields in tables. You can set the field to the same value
for every row using an Update query. The SQL of the query would look
something like:

UPDATE MyTable
SET MyField = "My Value"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top