This is the SQL I have:<br>tempsql = "SELECT PONumber, InvoiceNumber, Vendor, [Part Rec'd], NumofPieces, [Date Rec]"<br> tempsql = tempsql & " FROM [SR-LOG]"<br> tempsql = tempsql & " WHERE [Date Rec] Between " & Me!date1 & " And " & Me!date2 & ";"<br><br>Use it to make a querydef. If I made a normal query it would display the records between the dates I enter so I know there should be data.<br>This line:<br>Set rst2 = qdfTemp.OpenRecordset(dbOpenDynaset, dbReadOnly)<br><br>Is what gets highlighted in yellow after it says division by zero. PLEASE tell me whats going on, I can't put up with this for very much longer. <br><br>-Stressed