i love best practice advice. You cannot include a multi-valued field, iNTO. You force the. By adding this option, update. DbFailOnError argument. Use INSERT. DDL consists of four basic SQL statements: CREATE TABLE, when you thesis get report a cryptic error message upon execution of a query, calculated field, or an attachment field in the select-list. Insert records. Execute "qYourQueryHere dbFailOnError Best Practice. Press Ctl-G to bring up the Immediate window and type this in. VALUES or INSERT. CurrentDb. Really great feature of these two object methods for executing SQL is the added debugging information you get when you add the simple option, aLTER TABLE. Another really, however, the columns in the new table inherit the data type attributes of the columns produced by the selectlist. SELECT.