Access Question I guess

[rbsmit02]

How would I make an SQL statement to pull records between a date range?

MySql = "SELECT" & one & two & three & four & " FROM tracker WHERE " & _
    "[" & search_value2 & "]='" & search_value & "';"

Maybe Something like this:

MySql = "Select [agent] FROM tracker WHERE " & _
"[stamper2] (is between) '" & condition1"' '" & condition2 & "';"

Im not sure which operators mean what in SQL.

 

[Norie]

If it is Access you are using you can use the Between operator:

SELECT Table2.*
FROM Table2
WHERE (Table2.MyDate) Between #1/1/2004# And Date();

 

[rbsmit02]

well thanks anyway but I guess this will do:
[tbdate] BETWEEN date1 AND date2;