I want my query to return records between specific dates, or if the date fields are left null then bring back all records. The first part works, but cant get my head round how to bring back all records ( Or should I set the default values as min and max dates ?)
Between [Forms]![frmsupplier]![cboxstart] And [Forms]![frmsupplier]![cboxEnd]
Between [Forms]![frmsupplier]![cboxstart] And [Forms]![frmsupplier]![cboxEnd]