SELECT Sheet2.字段1, Sheet2.字段7, Sheet2.字段8, Sheet2.字段9, Sheet2.字段10, Sheet2.字段11, Sheet2.字段12, Sheet2.字段13, Sheet2.字段14, Sheet2.字段15, Sheet2.字段16, Sheet2.字段17, Sheet2.字段18
FROM Sheet2
WHERE (((Sheet2.字段7)=IIf(Left([字段7],4)="[释义]",[字段7],"")) AND ((Sheet2.字段8)=IIf(Left([字段8],4)="[释义]",[字段8],"")) AND ((Sheet2.字段9)=IIf(Left([字段9],4)="[释义]",[字段9],"")) AND ((Sheet2.字段10)=IIf(Left([字段10],4)="[释义]",[字段10],"")) AND ((Sheet2.字段11)=IIf(Left([字段11],4)="[释义]",[字段11],"")) AND ((Sheet2.字段12)=IIf(Left([字段12],4)="[释义]",[字段12],"")) AND ((Sheet2.字段13)=IIf(Left([字段13],4)="[释义]",[字段13],"")) AND ((Sheet2.字段14)=IIf(Left([字段14],4)="[释义]",[字段14],"")) AND ((Sheet2.字段15)=IIf(Left([字段15],4)="[释义]",[字段15],"")) AND ((Sheet2.字段16)=IIf(Left([字段16],4)="[释义]",[字段16],"")) AND ((Sheet2.字段17)=IIf(Left([字段17],4)="[释义]",[字段17],"")) AND ((Sheet2.字段18)=IIf(Left([字段18],4)="[释义]",[字段18],"")));
我切换到SQL视图后,发现是AND关系,给改成OR了。出结果了。
但是 有些字头的字段中不是以"[释义]"开头的也提取出来了。
究竟该如何解决啊?
刚学ACCESS,不太懂。 |