How do I copy text down a column in Access?

[administrator]

I am making a data base of addresses. The last three columns have the same
information. Is there a way to copy the text down the way you do in Excel?

 

[Rick Brandt]

I am making a data base of addresses. The last three columns have
the same information. Is there a way to copy the text down the way
you do in Excel?

A database is not a spreadsheet. Use an Update query.

Update TableName
Set Field1 = This,
Field2 = That,
Field3 = TheOtherThing

 

[Rick B]

Not really. You would typically be entering data one record at a time in a
form, not entering it down a list in the table like Excel. When you enter a
record, you can set up the form to DEFAULT an entry in certain fields.
Another option is to press CTRL-' while in a field. This will copy the
value from the previous record. The last option I can think of (and the one
you will most likely want) is to create an update query and have it locate
all records where STATE is blank, and update it with your state. Do the
same for CITY and ZIP.

Hope that helps.

Rick B

I am making a data base of addresses. The last three columns have the same
information. Is there a way to copy the text down the way you do in

Excel?

 

[Roger Carlson]

You are doing what we call "Committing Spreadsheet". As one of the "Ricks"
said, Access is not a speadsheet and you need to stop thinking in those
terms. If information is stored multiple times, it is time to look into
creating a separate table for this information and relate it to the main
table. This process is called "Normalization" and it is unfamiliar with the
term, you really need to do some research. Here are some links:

http://www.datamodel.org/NormalizationRules.html
http://support.microsoft.com/default.aspx?scid=kb;en-us;q209534
http://support.microsoft.com/default.aspx?scid=kb;EN-US;164172
http://support.microsoft.com/default.aspx?scid=KB;en-us;q234208

Also, I have some tutorials on database design on my website, here:
http://www.rogersaccesslibrary.com/TutorialsDesign.html

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

I am making a data base of addresses. The last three columns have the same
information. Is there a way to copy the text down the way you do in

Excel?