Currently I have a form that accepts a Beg_Date and End_Date. The user is not required to enter any dates. If the fields are empty when the form is submitted, the value "Null" is stored in the Access database. When the user wants to create a report, they can use the date fields to narrow the search. How can I bring back all records that are between i.e. 5/12/99 and "Null"?<BR><BR>Here is my "where" clause:<BR>strSQL1 = strSQL1 & " where Tra_BegDate >= #" & strBeg_Date & "# and Tra_BegDate = "Null"<BR><BR>Thanks.