Office中国论坛/Access中国论坛

标题: [求助]请教SELECT WHERE 问题 [打印本页]

作者: Nicole_20051 时间: 2005-8-30 04:02
标题: [求助]请教SELECT WHERE 问题
请帮忙指出问题错在哪？

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 时间: 2005-8-30 18:40
WhereClause = WhereClause & " and ([" & subtable & "].[PEC] like " & Me![PEC] & "*" & "))；WhereClause = WhereClause & " and (['" & subtable & "'].[PEC] like '" & Me![PEC] & "'*" ))；

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

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

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)