Full Version: Criteria To Filter Blank Records
UtterAccess Forums > Microsoft® Access > Access Forms
foxtrojan
I'm trying to do a criteria to show a listing, but just cannot get it right.
DoCmd.OpenForm "frmDeliveryOrderList", acNormal, "", "InvoiceID = Is Null"
What I want is to list all Delivery Orders without an InvoiceID. Can you experts out there please help.
azolder
Try
CODE
InvoiceID Is Null

or
CODE
Nz(InvoiceID,0)=0
foxtrojan
Thank you so much John. Simple and nice. Yes, got it working.
LPurvis
Just to mention, of the two suggestions by azolder - the former... please do go for the former. ;-)

Cheers
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.