Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
I think it should be
IsNull([Product Name]) = -1 .
If you can attach a sample application then it would be more clear.
Deepak
I think I found it
=if(IsNull(ProductField),1,0)
I think I found it
=if(IsNull(ProductField),1,0)
But it doesn't work with all my validation tables oddly enough. Works with Product reference table but not with Partner reference table
But it doesn't work with all my validation tables oddly enough. Works with Product reference table but not with Partner reference table