How do I copy text down a column in Access?

G

Guest

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?
 
R

Rick Brandt

administrator said:
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
 
R

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


administrator said:
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?
 
R

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

administrator said:
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?
 
Joined
Oct 23, 2023
Messages
1
Reaction score
0
This may not be elegant but it will work.
In any column that is blank but all the values are the same for each record:
1) Copy any existing column values into the blank column.
2) For the newly "filled" column, replace "*" with the "new desired 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