Conditional Format Query!

B

Bob Vance

This gives my box an alert if Email is over 30 days, but if there is no date
I dont want to get the warning, can this be added?

([ckBachInvoice]=-1) And ([tbAmountOwe]>1) And
((DateDiff("d",[tbEmailState],Date())>=30) Or IsNull([tbEmailState]))
 
B

Bob Vance

Fix it thanks added a ceck box for no alert...Regards BOb

([ckBachInvoice]=-1) And([ckNoAlert]= 0) And ([tbAmountOwe]>1) And
((DateDiff("d",[tbEmailState],Date())>=30) Or IsNull([tbEmailState]))
 
Top