Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to make a bookmark using advanced search in order to display rows in a table with null date values.
When I set this :
= [date_test] <> ''(the same with null()) or
=IsNull([date_test]) = 0
it works (displaying only rows without null values in this field, but when I try the opposite :
=[date_test] = ''(the same with null())or
=IsNull([date_test]) = 1
it doesn't work. The filter doesn't give me good results. It should display rows with null values in this table.
Why ?
Manual:
IsNull( expr )
Returns -1 (true) if expr returns NULL, otherwise 0 (false).
I am trying to create a bookmark to pull only those records where the data is in one table but no match in the other table.
Example:
Product ID is in Sales table but the Product ID is not yet added to the Product table.
THus the Product Name is Null in the query
I tried the below and no luck
=IsNull([Product Name]) = 1