ChadLittle
asked on
How to make VBA query for an empty field
Hi,
I am trying to find fields in a query that are empty or null. Here is an example:
Thank you for your help.
Chad
I am trying to find fields in a query that are empty or null. Here is an example:
SELECT tblPOHeader.ManufacturerID, tblPOHeader.POHeaderID, tblPOHeader.PVID
FROM tblPOHeader
WHERE (((tblPOHeader.PVID)=IsNull));
What do I put in the place of "IsNull" in line 3?Thank you for your help.
Chad
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
My first example was wrong but the 2nd one I gave or the one Cluskitt gave will work.
ASKER
You answered that in 3 minutes! Thanks for your help. Next time I will hold my breath!
Chad
Chad
Open in new window
OrOpen in new window