<div>
You could try
<pre><code id="code-20-38152693-1">SELECT tblPOHeader.ManufacturerID, tblPOHeader.POHeaderID, tblPOHeader.PVID
FROM tblPOHeader
WHERE tblPOHeader.PVID=NULL</code></pre>
Or
<pre><code id="code-20-38152693-2">SELECT tblPOHeader.ManufacturerID, tblPOHeader.POHeaderID, tblPOHeader.PVID
FROM tblPOHeader
WHERE IsNull(tblPOHeader.PVID)</code></pre>
</div>


You could try

SELECT tblPOHeader.ManufacturerID, tblPOHeader.POHeaderID, tblPOHeader.PVID
FROM tblPOHeader
WHERE tblPOHeader.PVID=NULL

Or

SELECT tblPOHeader.ManufacturerID, tblPOHeader.POHeaderID, tblPOHeader.PVID
FROM tblPOHeader
WHERE IsNull(tblPOHeader.PVID)

<div>
My first example was wrong but the 2nd one I gave or the one Cluskitt gave will work.
</div>


My first example was wrong but the 2nd one I gave or the one Cluskitt gave will work.

<div>
You answered that in 3 minutes! &nbsp;Thanks for your help. &nbsp;Next time I will hold my breath!<br />
Chad
</div>


You answered that in 3 minutes!  Thanks for your help.  Next time I will hold my breath!
Chad

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am trying to find fields in a query that are empty or null. &nbsp;Here is an example:
<pre><code id="code-10-27779976-1">SELECT tblPOHeader.ManufacturerID, tblPOHeader.POHeaderID, tblPOHeader.PVID
FROM tblPOHeader
WHERE (((tblPOHeader.PVID)=IsNull));</code></pre>
What do I put in the place of &quot;IsNull&quot; in line 3?<br />
Thank you for your help.<br />
Chad
</div>
</div>


Hi,

I am trying to find fields in a query that are empty or null.  Here is an example:(CODE)What do I put in the place of "IsNull" in line 3?
Thank you for your help.
Chad

How to make VBA query for an empty field

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.