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

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

Guest

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?
 
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"
 
I might add to the answer Douglas gave. If you have a lot of repeating
data, then it would appear likely that you have a bad table design and
likely that data may be better placed in a different table and related to
the first table. It is hard to make that determination on line as a very
good understanding of the data is necessary. I suggest that you do some
research into - Normalized - table design.
 
Back
Top