Copy Field_B contents to Field_C permanently

  • Thread starter Thread starter BobG
  • Start date Start date
B

BobG

1. Access 2000
2. Old "Flat" Database Table (880 records)
3. New "Relational" Database Table(s)

Objective: Move Old field column data into New field
column and thereby eliminate repititious data entry.

Note: The New table has the Old fields next to the New
fields. Old fields contain data, New fields are blank
(combo boxes).

Background:

a. In my New table the Old field "Category" is next to the
New field "Category2"
b. The Old "Category" column is populated with data.
c. The New "Category2" column is blank, of course, and
awaits my selection from the combo box.

Goal: Automatically move the existing information from the
Old field "Category" into the New field "Category2"
(afterwards I can delete the Old field "Category" and
begin anew with "Category2")

I am thankful for ideas on how to do it.
 
Hi Bob

maybe i'm missing something but if you want all the entries from B in C
won't that make C the same as B?

however, to do it, use an update query
go to the query window
choose create query in design view
double click on your table
close the choose table dialog box
double click on field C
under query on the menu choose Update query
in the update to line type
ie the name of your field in square brackets
then press on the red exclaimation mark - all values from B will be copied
to C.

Cheers
JulieD
 
Goal: Automatically move the existing information from the
Old field "Category" into the New field "Category2"
(afterwards I can delete the Old field "Category" and
begin anew with "Category2")
Click to expand...

Create a Query based on the table. Change it to an Update query (using
the Query menu item or the query-type icon).

On the UpdateTo row under Category2 type

[Category]

Run the query using the ! icon.
 
Back
Top