<div>
I normally use an IIF statement to translate a null value to something feasible.<br />
<br />
iif ([From] is null, &quot;Todays Date&quot;, [From])<br />
<br />
Please excuse my pseudo code above as I have not used access in a number of years.<br />
<br />
I hope this points you to a solution.
</div>


<div>
The null issue is not tied to the field, I am referring to my actual record. Some of my records don't have any dates. Date value is null. I would like them to be included in the query; even though they don't have a date.
</div>


<div>
I agree with the above, the only consideration then will be where the dates will end up if they are null with regard to the ordering hence my suggestion of IIF
</div>


<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I have a listbox that has a row source of a query of a table. <br />
<br />
In my query, I filter with a date range. <br />
<br />
In the criteria field for the &quot;Date&quot; <br />
<br />
Between NZ([From],#1/1/1900#) And Nz([To],#12/31/9999#)<br />
<br />
Now, this works perfect. Only problem I realized is that some of my records don't have a date, i.e. is null. How do I modify the criteria expression to also accept Null dates. <br />
<br />
Thanks in advance, <br />
<br />

</div>
</div>


Hi, 

I have a listbox that has a row source of a query of a table. 

In my query, I filter with a date range. 

In the criteria field for the "Date" 

Between NZ([From],#1/1/1900#) And Nz([To],#12/31/9999#)

Now, this works perfect. Only problem I realized is that some of my records don't have a date, i.e. is null. How do I modify the criteria expression to also accept Null dates. 

Thanks in advance, 



I normally use an IIF statement to translate a null value to something feasible.

iif ([From] is null, &quot;Todays Date&quot;, [From])

Please excuse my pseudo code above as I have not used access in a number of years.

I hope this points you to a solution.

The null issue is not tied to the field, I am referring to my actual record. Some of my records don&#39;t have any dates. Date value is null. I would like them to be included in the query; even though they don&#39;t have a date.

I agree with the above, the only consideration then will be where the dates will end up if they are null with regard to the ordering hence my suggestion of IIF

Query a date range in access database

Hi, 

I have a listbox that has a row source of a query of a table. 

In my query, I filter with a date range. 

In the criteria field for the &quot;Date&quot; 

Between NZ([From],#1/1/1900#) And Nz([To],#12/31/9999#)

Now, this works perfect. Only problem I realized is that some of my records don&#39;t have a date, i.e. is null. How do I modify the criteria expression to also accept Null dates. 

Thanks in advance, 



Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.