I have the following formula in a query: Between NZ([Forms]![ReportForm]![txt1st],#10/11/2004#) And NZ([Forms]![ReportForm]![txt2nd],Date()) Instead of having #10/11/2004# as default date, I would like it to simply search for the earliest date entered in that field and start from it. Basically, I need the opposite of the Date() funciton, I need the earliest date to automatically calculate if nothing is put into the text field. Everything will be included this way. Does anyone know the formula command?