[求助]请教SELECT WHERE 问题

Nicole_20051

请帮忙指出问题错在哪？

WhereClause = " WHERE ((([" & subtable & "].[Date])>#" & TransformDateUS(Forms![tr main form]![date debut]) & "# "

     WhereClause = WhereClause & " And ([" & subtable & "].[Date])<#" & TransformDateUS(Forms![tr main form]![date fin]) & "# )"

     WhereClause = WhereClause & " AND (([" & subtable & "].[1st test])=" & """" & "fail" & """" & ")"

     WhereClause = WhereClause & " AND (([" & subtable & "].[COMMENT])= " & """" & Forms![tr main form]![CLASSI] & """" & ")"

  

     WhereClause = WhereClause & " And ([" & subtable & "].[PEC] like " & """" & Forms![tr main form]![PEC] & """" & """" & "*" & """" & "));"  （这句是无任何响应的）

而换成WhereClause = WhereClause & " and ([" & subtable & "].[PEC] like " & Me![PEC] & "*" & "))；老是出现:  Extra)in query expression'((([flash board].[date]>#8/22/2005# and [flash board].[date]<#8/29/2005#) and ((flash board].[1st test])="fail") and((flash board].[comment])="production") and (flash board].[pec] like ntum17aa*))'

请问何解？多谢先！

quanli

WhereClause = WhereClause & " and ([" & subtable & "].[PEC] like " & Me![PEC] & "*" & "))；WhereClause = WhereClause & " and (['" & subtable & "'].[PEC] like '" & Me![PEC] & "'*" ))；

Nicole_20051

首先：非常感谢你的帮忙！但它还是有以下的ERROR：改为WhereClause = WhereClause & " and (['" & subtable & "'].[PEC] like '" & Me![PEC] & "'*" ))；“ 后，出现ERROR: "Compile error:expected end of statement"请问又该如何处理？谢谢！

Nicole_20051

好奇怪，我将WhereClause = （['" & subtable & "'].[PEC] like '" & Me![PEC] & "'*" )的条件放在前面，其它条件在后。则可以正常运行，得到我想要的结果了。也不知道何解，有哪位朋友知道吗？谢谢！[em06]