I have a list of product serial numbers and the dates the numbers were issued in an access database. I am querying from a VB program which lets the users pick a start and end date to assign the relevant serial numbers within that date range to a recordset.

I can a list for a specific date using SQL = "SELECT * From Serial WHERE Date LIKE " & "'" & FirstDate & "'"
Set rsFirst = cnn1.Execute(SQL, , adCmdText)

But can anyone tell me how to populate a recordsetwith dates in a range of say June 3rd to june 24th?

Thank you.