Help with Between in SQL string

[deadhead7]

Need help with this code, I need to do a Between/And for the FROM_DATE and this code has something wrong with it and can not figure it out, Please help

stlinkcriteria = "HICN = '" & Me![HICN] & "' and UPIN = '" & Me![UPIN] & "'" & _
Between "[FROM_DATE]=" & "#" & Me![FROM_DATE] & "#" & _
and "[FROM_DATE]=" & "#" & Me![FROM_DATE] & "#

 

[bboffin]

The syntax for Between is:

ColumnName Between LowValue and HighValue

So try:

stlinkcriteria = "HICN = '" & Me![HICN] & "' and UPIN = '" & _
Me![UPIN] & "' AND [FROM_DATE] " & _
"Between #" & Me![FROM_DATE] & _
"# And #" & Me![TO_DATE] & "#"

This assumes you have a control called [TO_DATE] on your form. If the end date is calculated use the DateAdd function to produce the end date.