IsNull([date to HQ]) And ([award number]<>("0" Or "1" Or "7"))

F

franklinbukoski

I'm trying to make this work, I think there must be something wrong with the
last part?

Forgive this double post, I am trying to make this work by a certain time
today.

Thank you,
 
T

Tom Lake

franklinbukoski said:
I'm trying to make this work, I think there must be something wrong with
the
last part?

Forgive this double post, I am trying to make this work by a certain time
today.

IsNull([date to HQ]) And [award number]<> 0 And [award number] <> 1 And
[award number] <>7



Tom Lake
 
J

John W. Vinson

I'm trying to make this work, I think there must be something wrong with the
last part?

Forgive this double post, I am trying to make this work by a certain time
today.

Thank you,

([date to HQ] IS NULL AND [AwardNumber] NOT IN("0", "1", "7")

assuming that AwardNumber is of Text type; if it's a number field omit
the " delimiters.

John W. Vinson [MVP]
 
F

franklinbukoski

Thank you both very much!

John W. Vinson said:
I'm trying to make this work, I think there must be something wrong with the
last part?

Forgive this double post, I am trying to make this work by a certain time
today.

Thank you,

([date to HQ] IS NULL AND [AwardNumber] NOT IN("0", "1", "7")

assuming that AwardNumber is of Text type; if it's a number field omit
the " delimiters.

John W. Vinson [MVP]
 
Top