Cond Format:

F

franklinbukoski

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"))
 
F

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"))
Click to expand...

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.
 
F

franklinbukoski

thank you!

fredg said:
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"))
Click to expand...

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.
Click to expand...
 
Top