Cond Format:

[Guest]

Good morning,

I would like a coniditional format to reflect the following on a form and
report in reference to timely award submissions:
If date to hq field is empty and the current date is >= date due to HQ (then
red); Or date to HQ>when it was due (then red);
Or if date to hq field is empty and the authority for the award is with the
company level, meaning it does not have to go to the HQ, do not count those
as red.
This is how I wrote it and everything works except for the last part
(IsNull([date to HQ]) And ([award number]<>("0" Or "1" Or "7"))

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

 

[fredg]

Good morning,

I would like a coniditional format to reflect the following on a form and
report in reference to timely award submissions:
If date to hq field is empty and the current date is >= date due to HQ (then
red); Or date to HQ>when it was due (then red);
Or if date to hq field is empty and the authority for the award is with the
company level, meaning it does not have to go to the HQ, do not count those
as red.
This is how I wrote it and everything works except for the last part
(IsNull([date to HQ]) And ([award number]<>("0" Or "1" Or "7"))

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

You must repeat the field name for each criteria.
(IsNull([date to HQ]) And ([award number]<> "0" Or [award number] <>
"1" Or [award number] <> "7"))

You may have to also enclose some of this criteria within additional
parenthesis so that Access groups it properly.

 

[Guest]

thank you!

Good morning,

I would like a coniditional format to reflect the following on a form and
report in reference to timely award submissions:
If date to hq field is empty and the current date is >= date due to HQ (then
red); Or date to HQ>when it was due (then red);
Or if date to hq field is empty and the authority for the award is with the
company level, meaning it does not have to go to the HQ, do not count those
as red.
This is how I wrote it and everything works except for the last part
(IsNull([date to HQ]) And ([award number]<>("0" Or "1" Or "7"))

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

You must repeat the field name for each criteria.
(IsNull([date to HQ]) And ([award number]<> "0" Or [award number] <>
"1" Or [award number] <> "7"))

You may have to also enclose some of this criteria within additional
parenthesis so that Access groups it properly.