MS Access question

[Sue]

I would like to make every entry in a column the same
thing. I would normally just copy and paste, but there
are 15,000 records. I know there is a procedure to do
this with keystrokes but I can't find it in the help
menu. I would appreciate your help. Thanks

 

[Douglas J. Steele]

The best approach would be to use an Update query.

Doing it via keystrokes, cut-and-paste or even VBA code are far less
desirable approaches.

 

[Sue]

Thanks Doug, I went to your website but couldn't find the
answer to my question. Could you please give me the
link? Thanks a lot!

 

[Douglas J. Steele]

I don't have anything about update queries at my site.

Try taking a look at http://support.microsoft.com/?id=304355

 

[Sue]

Thanks for the link Doug, but thats not what I am looking
for. There is a keystroke command that copies the entire
column the same entry. I used it before but can't
remember what is is. Now I can't find it again in the
help menu.

 

[Douglas J. Steele]

Are you talking about Excel? This newsgroup is for questions about Access,
the database product that's part of Office Professional, and as far as I'm
aware, there's no such keystroke in Access.

 

[Ken Snell [MVP]]

Ctrl+' will copy the value of the field in the previous record, if that's
what you're seeking.