Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
ISNULL(Fieldname) <> -1 means what?
ISNULL(Fieldname) <> -1
ISNULL(Fieldname) <> TRUE()
ISNULL(Fieldname) = FALSE()
NOT ISNULL(Fieldname)
Means if Fieldname is not null
ISNULL(Fieldname) <> -1
ISNULL(Fieldname) <> TRUE()
ISNULL(Fieldname) = FALSE()
NOT ISNULL(Fieldname)
Means if Fieldname is not null
-1 corresponds to the value true.
The expression equals:
IsNull(FiueldName) <> true()
Take text-box & put =ISNULL(Fieldname)
If result is -1 then it states field contains Null values else if returned result is 0 then not null..