Hi

I am new to all of this and wanted some advice I have the following in add.asp, it should feed the data into my database, but I get JET Database error. I have worked out that it is to do with T7 as it is a check box but I am unsure of the correct way to pass this to the table.

Any help would be much appreciated.

If Request.Form("T1") > "" Then
    uid = Request.Form("T1")
    pwd = Request.Form("T2")
    titl = Request.Form("T3")
    wor = Request.Form("T4")
    mob = Request.Form("T5")
    fax = Request.Form("T6")
    admin = Request.Form("T7")
Else
    uid = Request.Form("T3")
    pwd = Request.Form("T4")
End If

If Request.Form("T1") > "" Then
    SQL = "Insert INTO contacts (uid,pwd,titl,wor,mob,fax, admin) Values ('" & uid & "','" & pwd & "','" & titl & "','" & wor & "','" & mob & "','" & fax & "','" & admin & "')"
Else
    SQL = "Insert INTO adminq (uid,pwd,admin) Values ('" & uid & "','" & pwd & "', True)"
End If

It's ok sorted it, it was the SQL line:
    SQL = "Insert INTO contacts (uid,pwd,titl,wor,mob,fax, admin) Values ('" & uid & "','" & pwd & "','" & titl & "','" & wor & "','" & mob & "','" & fax & "'," & admin & ")"

What was wrong with the SQL line??????

('.')