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

[Guest]

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,

 

[Tom Lake]

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

 

[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]

 

[Guest]

Thank you both very much!

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]