Hi,

I have an access DB with a field (MailDateSent), I want to sort between 2 dates, my code below is not working.

Any help appreciated.

Regards,

Alan.

Date1 = txtDate1.Text
Date2 = txtDate2.Text

'SQL = "SELECT * FROM Customers WHERE (MailDateSent) >= Date1 and (MailDateSent) <= Date2 ORDER bY CompanyName"

Set Customers = DB.OpenRecordset(SQL, dbOpenDynaset)