这两条access语句怎么错了

[wtjxjxsd]

insert into userinformation(id,username,userpsw,usedate) values (num,t1.Text,t2.Text,t1.date);num是自动添加列，usedate是时间；
UPDATE t_d_CardRecord where f_ReadDate=#%s# set f_Character=1 f_ReadDate是时间；谢谢

[WWWWA]

自增可以不写
"insert into userinformation([username],userpsw,usedate)
values (" & t1.Text & "," & t2.Text & "," & t1.date)

UPDATE t_d_CardRecord set f_Character=1 where f_ReadDate=#2008-1-1#

[ewang11]

字符型的两边加'",数字类型加",日期类型加#
insert into userinformation(id,username,userpsw,usedate) values ("& num & ",'" & t1 & "','" & t2 & ",#& t1.date &#)

ID 是自动编号,可以不用INSERT ,它会自动增加的

[WWWWA]

"insert into userinformation([username],userpsw,usedate)
values ('" & t1.Text & "','" & t2.Text & "',#" & t1.date & "#")

[wtjxjxsd]

谢谢两位大哥，已经解决