Populating a new field

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
 
K

KARL DEWEY

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.
 
C

chris.nebinger

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
 
Top