IS null

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

Hello,

Can anyone tell me how to look at to fields that are null
and have a result.

So example

If fieldA is null and FieldB is null then "Other"
 
In VB, this is
If ISNull(fieldA) And IsNull(fieldB) Then

Hope This Helps
Gerald Stanley MCSD
 
Hello,

Can anyone tell me how to look at to fields that are null
and have a result.

So example

If fieldA is null and FieldB is null then "Other"
Click to expand...

If IsNull([FieldA]) And IsNull([FieldB]) Then
^Do something here^
End If
-D
 
Duncan Bachen said:
Hello,

Can anyone tell me how to look at to fields that are null
and have a result.

So example

If fieldA is null and FieldB is null then "Other"
Click to expand...

If IsNull([FieldA]) And IsNull([FieldB]) Then
^Do something here^
End If
-D
Click to expand...

Based on the newsgroup I'm assuming you want this in a query, not VBA code.

IIf([FieldA] Is Null And [FieldB] Is Null,"Other","SomethingElse")

(you didn't say what the field should return when both fields are NOT
Null).
 
Back
Top