View Full Version : Fill a Column in a Table?


Djblois
06-12-2009, 06:59 AM
Is there a way to fill a whole column in a Table? I want it to be filled completely with the same Code.

ColinEssex
06-12-2009, 07:04 AM
You want a column to be filled with code??? How many rows?

Col

MSAccessRookie
06-12-2009, 07:05 AM
Is there a way to fill a whole column in a Table? I want it to be filled completely with the same Code.

You can UPDATE the Table so that the Column has the new value.
UPDATE YourTable SET YourColumn=YourValue
Remember to use the proper DataType rules when defining YourValue (Nothing for numbers, " or ' for strings, and # for Dates)