fill multiple records with same data

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

This is a pretty simple question, but is driving me crazy. Using
Access 2002, I have created a table with field1, field2, and field3.

filed1 and field2 are last name, and first name. the third field is
text... the nams are all filled in, but how do I quickly populate
field3 other than ctrl+v to past into it? how do I fill hundreds by
selecting lots of records?

thanks in advance!
 
This is a pretty simple question, but is driving me crazy. Using
Access 2002, I have created a table with field1, field2, and field3.

filed1 and field2 are last name, and first name. the third field is
text... the nams are all filled in, but how do I quickly populate
field3 other than ctrl+v to past into it? how do I fill hundreds by
selecting lots of records?
Click to expand...

With an Update query. If you create a Query based on the table, change
it to an Update query, type "Really Good Person" on the UpdateTo line
under field3 (by the way: RENAME YOUR FIELDS to something meaningful!)
and run the query then every person in the table will become a Really
Good Person.

If you only have a limited number of Really Good People you can use
criteria to limit which records get updated.
 
Back
Top