Conditional Format Query!

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

 

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