Populate all fields in a column with same data

  • Thread starter Thread starter GLMoore
  • Start date Start date
G

GLMoore

Our office uses the Access Label Wizard; we work with a table where the data
comes from an imported text file.

We need to add one column to those that the text file requires, in order to
associate a file number with the address label info. I'm looking for a way
to copy that file number into all the fields in the newly-created column.

I'm hoping to find a non-programming way to do this, because the staff that
will need to do this work will not have training in database-making in Access
.... we are really just using the program for its Label Wizard capabilities.

We are currently typing the file number and then moving thru the cells of
the column, pasting in each cell -- not such a problem when the list is under
50 names, but many lists are hundreds of names.

Thanks for any help you can offer.

GLMoore
 
GL,

You can make an Update Query, based on the table, which would allow you
to update the entry in the field for all records in one hit.
 
Back
Top