Sort By Date

[aussiecyclone]

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)

[forty7]

I'm using SQL-Server so this may not be the right syntax for you, but I always have to put single quotes around dates.

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


thanx/good luck,
adam

[d.paulson]

In access you use the pound sign.

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

David Paulson