View Full Version : If Value is not null


Glowackattack
02-02-2009, 08:11 AM
How can i easily accomplish this?? I have two buttons, one that opens a form for records that are null so my code is this...

stLinkCriteria = "IsNull([Placed Date])"

And i want another that shows all records where [Placed Date] is not null...can i use...

stLinkCriteria = "Not IsNull([Placed Date])"

????

Thanks for hep in advance.

Glowackattack
02-02-2009, 08:28 AM
It looks like that works fine, but i'd like to know if there is a better way to accomplish it or if there is better syntax to use.