怎样可以实现sql语句的多条件查询

ac_ca

condition = " where " & 查询项目.Value
If 运算符.Value = "between" Then
condition = condition & " between " & con1 & " and " & con2 & "and 查询项目1.Value like '%" & 条件值3.Value & "%'"
请前辈们指点这句语句那里不正确？

ac_ca

有高人指点下吗？谢谢！

ly

日期一般需要两端加#
试一试，还不行的话把样本发上来

ac_ca

日期两端我加了#号，但还是不行！请老师指点下！！！

con1 = "#" & 条件值1.Value & "#"
con2 = "#" & 条件值2.Value & "#"
con3 = "'" & 条件值3.Value & "'"
ElseIf 查询项目.Value = "借方发生额" Or 查询项目.Value = "贷方发生额" Or 查询项目.Value = "余额" Then
con1 = Val(条件值1.Value)
con2 = Val(条件值2.Value)
Else
con1 = "'" & 条件值1.Value & "'"
con2 = "'" & 条件值2.Value & "'"
End If
condition = " where " & 查询项目.Value
If 运算符.Value = "between" Then
condition = condition & " between " & con1 & " and " & con2 "and " & 查询项目2.Value & 运算符2.Value & con3
ElseIf 运算符.Value = "like" Then
condition = condition & " like '%" & 条件值1.Value & "%'"

ly

ac_ca 发表于 2021-11-25 15:53
日期两端我加了#号，但还是不行！请老师指点下！！！

con1 = "#" & 条件值1.Value & "#"

1. condition = condition & " between " & con1 & " and " & con2 & "and " & 查询项目2.Value & 运算符2.Value & con3
   

复制代码

ac_ca

代码运行还是查询不到结果！

ly

ac_ca 发表于 2021-11-26 21:13
代码运行还是查询不到结果！

语法结构没有问题，在书写时要注意格式：

1. con3 = "'%" & 条件值3.Value & "%'"

复制代码

1. condition = condition & " between " & con1 & " and " & con2 & "and " & 查询项目2.Value & " " & 运算符2.Value & con3

复制代码

ac_ca

ly 发表于 2021-11-27 11:18
语法结构没有问题，在书写时要注意格式：

谢谢老师指点！！！！