access 问题

[zsge]

我 在VB access 中用select * from database where fields1=A1 and ... and fieldsN=AN
N>50 语句查找记录时，提示语句太复杂?该如何办？

[Wingsun]

将一条SQL拆解成好几句，如 Select * Into temp From Database Where Field1=A1....; Select * from Temp Where Field2=A2...;