K KansasAU Guest Sep 12, 2003 #1 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?
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 Registered User. Local time , 23:01 Joined Apr 24, 2002 Messages 588 Sep 12, 2003 #2 Create an "Update" query. Drag the new column name to the grid. Put zero in the "update to" cell. Run the query. RichM
Create an "Update" query. Drag the new column name to the grid. Put zero in the "update to" cell. Run the query. RichM