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

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?
 
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"
 
J

Joseph Meehan

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.
 

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