Well I figured "Date" was a reserved word and changed it, but still get the same issue:

Syntax error in UPDATE statement.

The error occurred in D:\Hosting\uticarenew\Admincopy\UticaUpdatedJobInf o.cfm: line 92
90 : Date = '#Form.Calendar#',
91 : Active = '#Form.Active#'
92 : WHERE AutoID = #Form.AutoID#
93 : </cfquery>
94 : <cfoutput>
SQL UPDATE Gas SET Model = 'Blake', MPG = 20, Date = '1/11/01', Active = 'Yes' WHERE AutoID = 6
DATASOURCE UticaRenew_accesscf_Mileage
VENDORERRORCODE 3092
SQLSTATE &nbsp;

Also, the Date or "Calendar" field as it is labeled in the database, is a text field, hense the quotes. Active is a checkbox with a "Yes" value

Dave