L.DAL=#" & Format(Me.DAL.Text, "MM/DD/YYYY") & "# AND L.AL<=#" & Format(Me.AL.Text, "MM/DD/YYYY") & "#
have the same result when i use a Between in quey, or not?
perphs i'm stupid!
Logical ....
-
HansV
- Administrator
- Posts: 78629
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Logical ....
No, since you have = in the first part, and since the first uses L.DAL and the second part uses L.AL.
Between works if you have >= and <= conditions on the same field.
Between works if you have >= and <= conditions on the same field.
Best wishes,
Hans
Hans