Hi all
Anyone out there knows any SQL for comparing dates?
for example if i type in 1/1/2000 and 1/12/2000 it will display all the record between those date

Code:
Data1.RecordSource = " select productname,month, count(productcodeno) as count, SUM(orderdeliver)AS sum from customerpricelist  where month  = #" & strDate & "# and #" & strdate2 & "# group by productname,month"
  

 Data1.Refresh
That is the current code i have but it fails to do the job