Conditional Format Query!

  • Thread starter Thread starter Bob Vance
  • Start date Start date
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]))
 
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]))
 
Back
Top