added new column no need to add data to old records

[Guest]

I added a new column to my database which has 4k records. How can i add the
new information to those 4k records without going line by line.

 

[Joseph Meehan]

I added a new column to my database which has 4k records. How can i
add the new information to those 4k records without going line by
line.

What data are you adding? Is it all the same? If not how are you going
to identify what to add to what record?

If it is all the same, why add it to the table?

 

[Luke Dalessandro]

What you want is to run an update query on that table setting the field
to whatever you want... it can be calculated from other values in the
table, or selected out of another table based on some criteria...

You really will need to give more information if you need more specific
help.

Good luck,
Luke