<div>
You can use the Nz function:<br />
<br />
SELECT Nz(YourFieldName, &quot;0&quot;) AS SomeField FROM SomeTable
</div>


You can use the Nz function:

SELECT Nz(YourFieldName, "0") AS SomeField FROM SomeTable

<div>
This doesn't seem to work Scott, my field is called InvoiceDate and if its 'blank' I want to force a '0'?
</div>


This doesn't seem to work Scott, my field is called InvoiceDate and if its 'blank' I want to force a '0'?

<div>
post the sql statement of your query
</div>


<div>
<blockquote>
my field is called InvoiceDate and if its 'blank' I want to force a '0'
</blockquote>
<br />
You cannot mix dates with a string. So what are you actually doing?<br />
<br />
/gustav
</div>


> my field is called InvoiceDate and if its 'blank' I want to force a '0'


You cannot mix dates with a string. So what are you actually doing?

/gustav

<div>
The &quot;0&quot; date is Dec 30, 1899. &nbsp;Remember dates are not stored as strings. &nbsp;Dates are stored as double precision numbers with the integer porting being the number of days since the &quot;0&quot; date and the decimal as the fraction of time since midnight.
</div>


The "0" date is Dec 30, 1899.  Remember dates are not stored as strings.  Dates are stored as double precision numbers with the integer porting being the number of days since the "0" date and the decimal as the fraction of time since midnight.

<div>
There is no need to check for a &quot;valid date&quot; as a date field only can hold either a valid date or - if the field allows - Null.<br />
So just check for Null if that is your case - what you actually are trying to do is still a secret.<br />
<br />
/gustav
</div>


There is no need to check for a "valid date" as a date field only can hold either a valid date or - if the field allows - Null.
So just check for Null if that is your case - what you actually are trying to do is still a secret.

/gustav

<div>
Right, if it is a Date field.
</div>


<div>
<div class="content wysiwyg-content">
I have a query that returns a value if an invoice is overdue, and it shows a blank if not. <br />
<br />
I would like to replace the blank field with a zero, can anyone help?
</div>
</div>


I have a query that returns a value if an invoice is overdue, and it shows a blank if not. 

I would like to replace the blank field with a zero, can anyone help?

How to replace a blank field with a zero in a query in Access 2010

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.