XXX Chats

Look at the SQL code there and you will have an example.

Otherwise the Help doesn't mention the multiple fields but give the general info.

Syntax update statement ::= Description of the illustration update_Keyword and Parameter Description alias Another (usually short) name for the referenced table or view, typically used in the contains references to columns in the table being updated, the references are resolved in the context of the current row.

Set dbs = Open Database("Northwind.mdb") ' Change values in the Reports To field to 5 for all ' employee records that currently have Reports To ' values of 2. Execute "UPDATE Employees " _ & "SET Reports To = 5 " _ & "WHERE Reports To = 2;" dbs.

You need an exclusive lock on affected rows either way. If you are dealing with a huge number of rows and you don't need a consistent state (all rows or none), you can split the operation into multiple batches. ) Increases the total cost, but keeps the lock time per row shorter.

If you just want to do it, then PEB's answer helps you to do it easily.

If you want the syntax then follow instructions in PEB's then select View / SQL view.

To add one record to a table, you must use the field list to define which fields to put the data in, and then you must supply the data itself in a value list. For example, the following statement will insert the values "1", "Kelly", and "Jill" into the Customer ID, Last Name, and First Name fields, respectively.

To add many records to a table at one time, use the INSERT INTO statement along with a SELECT statement.See Adrian thread on this is you're still confused.Quotes (') and Double-Quotes (") - Where and When to use them Mary Assuming Owner is a text field you will need the single quotes.Update query Add the table u want to update Add the records that should be updated...In the row Update to write "kdlsk" if kdlsk is the string that u want to update to your field If u want to update a field with the information from other field type: [The Source Field] Where The Source Field is the name of the field with the information!The column values returned by the subquery are assigned to the columns in the column list in order. WHERE search_condition Chooses which rows to update in the database table.The first value is assigned to the first column in the list, the second value is assigned to the second column in the list, and so on. Only rows that meet the search condition are updated.UPDATE Statement Creates an update query that changes values in fields in a specified table based on specified criteria.Syntax UPDATE table SET newvalue WHERE criteria; The UPDATE statement has these parts: Part Description table The name of the table containing the data you want to modify.newvalue An expression that determines the value to be inserted into a particular field in the updated records.criteria An expression that determines which records will be updated.

Comments Updating fields in sql