Frequently I use a Y/N field in a MS-Access table, such as IsActive Y/N. Reasoning aside, I have not needed to turn it to Yes with an SQL Insert until today. Is there a special way I need to format my SQL statement? (BTW, I am using the Command Object to execute my SQL, rather than a recordset.)<BR>-<BR>StrSQL = "INSERT INTO events (EventName, IsActive)" <BR>StrSQL = StrSQL & " VALUES(&#039" & EName & "&#039, True)"<BR><BR>Where "True" has been placed in single quotes, backeted etc., with out any luck. I can UPDATE correctly just not INSERT the Y/N field.<BR><BR>Thank you,<BR>Scott