Populating a new field

  • Thread starter Thread starter Tony Bender
  • Start date Start date
T

Tony Bender

I have a table with over 150,000 records (rows of data). I added a
new field called 'Department', and I'm trying to figure out how I can
populate all the cells in this new field to read DEPT.

I've tried copying one cell to another, but this takes forever.

Is there an easy way to do this?

Thank you
 
Seems to me that would be useless information for all 150K records to read
the same.
But an update query will do what you want.
 
Create a new query. View the SQL of it: (method depends on what
version you're using)

Type in:

UPDATE [YOUR TABLE NAME] SET Department = "DEPT"

Run it.


Chris
 
Back
Top