SQL to look between dates

[George Too]

Hi,

I have this SQL statement

"SELECT * FROM tblMain WHERE " & "Op Like " & """" & Me!cboSelect & "*" & """" & " Order By RunDate"

How do I make it to look for this data between between two dates specified by the user in a form?


ps. How do you pronounce "SQL"? Do you spell it out or is it pronounced "sequel"? (My friend wants to know)

 

[Rich]

Use the Between operator, and scrap the Like operator