How do I copy text down a column in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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?
Click to expand...

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

Update TableName
Set Field1 = This,
Field2 = That,
Field3 = TheOtherThing
 
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
Click to expand...
Excel?
 
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
Click to expand...
Excel?
 
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".
 
Back
Top