S smig Registered User. Local time Today, 10:52 Joined Nov 25, 2009 Messages 2,209 Apr 13, 2012 #1 there are two way to check for Null value in a query, and I wonder which one is better: IsNull([MyField]) [MyField] Is Null
there are two way to check for Null value in a query, and I wonder which one is better: IsNull([MyField]) [MyField] Is Null
J JANR Registered User. Local time Today, 09:52 Joined Jan 21, 2009 Messages 1,623 Apr 13, 2012 #2 http://allenbrowne.com/QueryPerfIssue.html JR