KansasAU
09-12-2003, 11:29 AM
I have an existing table with about 50k records. I have had to add a new column and need to add a 0 to every record in this column.
How is this done?
How is this done?
|
View Full Version : Need help inputing data to a column KansasAU 09-12-2003, 11:29 AM I have an existing table with about 50k records. I have had to add a new column and need to add a 0 to every record in this column. How is this done? RichMorrison 09-12-2003, 11:44 AM Create an "Update" query. Drag the new column name to the grid. Put zero in the "update to" cell. Run the query. RichM |