If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Repeating and item in a column
I have imported several tables into a database. One of the columns is the
city column. All of the records that are in the table are related to one particular city. Is there a way that I can enter the city in the very first record and copy it down the city column throughout the entire table? Seems like I remeber this being a feature in Access. Keep in mind these tables have already been imported with data in them. I want to add a column with the same entry for each record without having to enter them individually. |
#2
|
|||
|
|||
Use an Update query to populate the field.
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "faxylady" wrote in message ... I have imported several tables into a database. One of the columns is the city column. All of the records that are in the table are related to one particular city. Is there a way that I can enter the city in the very first record and copy it down the city column throughout the entire table? Seems like I remeber this being a feature in Access. Keep in mind these tables have already been imported with data in them. I want to add a column with the same entry for each record without having to enter them individually. |
#3
|
|||
|
|||
On Mon, 30 May 2005 14:39:01 -0700, "faxylady"
wrote: I have imported several tables into a database. One of the columns is the city column. All of the records that are in the table are related to one particular city. Is there a way that I can enter the city in the very first record and copy it down the city column throughout the entire table? Seems like I remeber this being a feature in Access. Keep in mind these tables have already been imported with data in them. I want to add a column with the same entry for each record without having to enter them individually. Just add the new City field, set its Default property to the desired city; and then run an Update query to update it to the desired city for the existing records. John W. Vinson[MVP] |
#4
|
|||
|
|||
Can you tell me how to do an update query? None of the sources I am using
gives me explicit directions on doing them. "John Vinson" wrote: On Mon, 30 May 2005 14:39:01 -0700, "faxylady" wrote: I have imported several tables into a database. One of the columns is the city column. All of the records that are in the table are related to one particular city. Is there a way that I can enter the city in the very first record and copy it down the city column throughout the entire table? Seems like I remeber this being a feature in Access. Keep in mind these tables have already been imported with data in them. I want to add a column with the same entry for each record without having to enter them individually. Just add the new City field, set its Default property to the desired city; and then run an Update query to update it to the desired city for the existing records. John W. Vinson[MVP] |
#5
|
|||
|
|||
On Tue, 31 May 2005 16:39:01 -0700, "faxylady"
wrote: Can you tell me how to do an update query? None of the sources I am using gives me explicit directions on doing them. You need better sources... g Create a new Query. Base it on your table. Select only the City field. Use the Query menu option, or the query-type tool in the toolbar (it's near the middle, just looks sort of like a datasheet and has a dropdown) to change the query to an Update query. A new row will appear in the query grid labeled Update To. Type "Schenectady" (or some other city of your choice) on this line. Run the query by clicking the red ! icon. You can put criteria on the Criteria line to make this a selective update - with no criteria, it will update every row. Use with caution, if the field you're updating contains data already it will be permanently and irreversibly overwritten! John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can a criteria be made to skip repeating information? | Polarbear | Running & Setting Up Queries | 3 | December 9th, 2004 06:33 PM |
Troubles with StyleRef field | Tim Tucker | Mailmerge | 4 | July 31st, 2004 01:50 AM |
Look up values in one column based on values in another without repeating | Frank Kabel | Worksheet Functions | 4 | April 8th, 2004 10:54 PM |
Look up values in one column based on values in another without repeating | fbarbie | Worksheet Functions | 0 | April 8th, 2004 09:38 PM |