<div>
You will probably have to build a query that include an alternative to a null. <br />
<br />
iif(not isnull([YourField]), [YourField],&quot;&quot;) &nbsp; &nbsp; if text<br />
iif(not isnull([YourField]), [YourField],0) &nbsp; &nbsp; if number<br />
<br />
Every possible field would have to include this function.<br />
You can access an Access Query just like an Access table from the 'outside' world.<br />
Scott C<br />

</div>


You will probably have to build a query that include an alternative to a null.

iif(not isnull([YourField]), [YourField],"")     if text
iif(not isnull([YourField]), [YourField],0)     if number

Every possible field would have to include this function.
You can access an Access Query just like an Access table from the 'outside' world.
Scott C


<div>
Create a query that opens your first query and change the names back again.<br />
Scott C
</div>


Create a query that opens your first query and change the names back again.
Scott C

<div>
sorry.. I see that in your previous comment..<br />
Scott C
</div>


sorry.. I see that in your previous comment..
Scott C

<div>
It did function, but I was hoping of a more nice way of handling the problem
</div>


It did function, but I was hoping of a more nice way of handling the problem

<div>
<div class="content wysiwyg-content">
When I use the command Application.ExportXML to export a query in MS Access (2007), the NULL value fields are not exported.<br />
Not even as blank tags (&lt;nullvaluetag&gt;&lt;/nullvalue<wbr />tag&gt;<br />
<br />
Am I not able to specify or do something to get tags generated also for fields with NULL values?<br />
I am exporting database changes to another system. Hence changes from a existing value to a NULL value is not exported!!
</div>
</div>


When I use the command Application.ExportXML to export a query in MS Access (2007), the NULL value fields are not exported.
Not even as blank tags (<nullvaluetag></nullvaluetag>

Am I not able to specify or do something to get tags generated also for fields with NULL values?
I am exporting database changes to another system. Hence changes from a existing value to a NULL value is not exported!!

Exporting NULL values from MS Access 2007 with the command Application.ExportXML

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.