Multiple condition query

[sathyaganapathi]

Hi,
Could you please help to combine below two quries under one?

If Me.ComboBox1.Value <> "Lab_Pending" And Me.ComboBox1.Value <> "ALL" Then
    qry = "SELECT * FROM TBL_PlabInput WHERE " & Me.ComboBox1.Value & " LIKE '%" & Me.TextSearch.Value & "%'"
End If

If Me.ComboBox1.Value = "ALL" And sDate <> "" And Me.ComboBox1.Value = "ALL" And eDate <> "" Then ' this is working
    qry = "SELECT * FROM TBL_PlabInput where Process_DateTime BETWEEN #" & sDate & "# AND #" & eDate & "#"
End If

Both are working fine when user separately.
when try to combine them together nothing worrks.
What I want is, first query to work when date range is given.
Please help.

 

[Micron]

.Value is the default property for most (all?) data controls. It's just that you don't need to use it but it's not wrong, just not common to do so.

I think that your issue was that you forgot the AND (logical) operator and used the concatenation operator (&) instead

Me.TextSearch & "%' & Process_DateTime BETWEEN
vs
Me.TextSearch & "%' AND Process_DateTime BETWEEN

 

[sathyaganapathi]

.Value is the default property for most (all?) data controls. It's just that you don't need to use it but it's not wrong, just not common to do so.

I think that your issue was that you forgot the AND (logical) operator and used the concatenation operator (&) instead

Me.TextSearch & "%' & Process_DateTime BETWEEN
vs
Me.TextSearch & "%' AND Process_DateTime BETWEEN

Dear Micron,
Got it... Thanks a lor for your support.
Have a nice day.

 

[Micron]

You're welcome. Glad I could help.