Using Access as a database

On the Insert Command how do I do a field that has a data type of Yes/No.

is it sql +="0,";

or sql+="'0'";

or what

Thanks in advance.

that would be a Bit value (1/0, yes/no, true/false) so itll just be 0 (for false) or 1 (for true):

sql += "0";

Also looks like you are using standard SQL "injection" - I would recommend using Stored Procedures as they are fast and secure and you don't need to worry about building the query string/SQL String/statement as it would be stored in the SPROC itself on the SQL Server. All you would have to do is supply the correct parameters with values in your Client app and call the stored procedure and thats it.