Where am I going wrong with this code?
I'm trying to retrieve all records that fall between
Date1 and Date2.
Is there a simpler way of writing SQL code like this?

Code:
Set rst = dbsRecdata.OpenRecordset("SELECT rechdr.recno, RecHdr.ponum," _
            & " RecHdr.daterecvd, RecLine.ItemNum, RecLine.Descrip, RecLine.QtyRecvd, RecLine.UnitPrice" _
            & " FROM RecHdr, RecLine" _
            & " WHERE RecHdr.recno = RecLine.recno" _
            & " and RecHdr.DateRecvd >= " & Date1 _
            & " And <= " & Date2 & "" _
            & " ORDER BY RecHdr.recno ASC,RecLine.descrip ASC", dbOpenDynaset)