SQL头疼

对#Error 3061的任何建议？ Thelma Lubkin skrev： Hi! Sorry...I made a mistake in pasting code. There are no parenthesis.There are no textboxes. ''Amount'' is an integer, ''MyDate'' is Date/Timeand ''Returned'' is a Yes/No field. The fields are identical in both tables. I was wondering....I''m running this ms access db 2000 on a machine withWin XP Pro installed and Office XP. Could this be an issue? I''ve had some other pecularities, so maybe others have had anyexperience with this configuration? Any suggestion to #Error 3061? Thelma Lubkin skrev: Allen Browne< Al ***** ****@SeeSig.Invalid>写道：：将文本框中的值连接成字符串： ：strPutBack =" INSERT INTO tblAmountItems（Amount，MyDate，Returned）" _ ：& SELECT Amount，MyDate，Returned _ ：& FROM tblOrderdetails _ ：& WHERE（tblOrderdetails.Returned = True）" _ ：& "）AND（tblOrderdetails.ItemID ="& / \ ||我认为这是一个太多的括号。 --thelma --- ------------------------------------------ ：Allen Browne - 微软MVP。西澳大利亚州珀斯。：访问用户提示 - http://allenbrowne.com/tips.html ：回复群组，而不是mvps dot org的allenbrowne。 Allen Browne <Al*********@SeeSig.Invalid> wrote: : Concatenate the values from the text boxes into the string: : strPutBack = "INSERT INTO tblAmountItems(Amount,MyDate,Returned) " _ : & "SELECT Amount,MyDate,Returned " _ : & "FROM tblOrderdetails " _ : & "WHERE (tblOrderdetails.Returned = True) " _ : & ") AND (tblOrderdetails.ItemID = " & /\ || I think that this is one parenthesis too many. --thelma --------------------------------------------- : Allen Browne - Microsoft MVP. Perth, Western Australia. : Tips for Access users - http://allenbrowne.com/tips.html : Reply to group, rather than allenbrowne at mvps dot org. 这篇关于SQL头疼的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！