Cool, I'll be trying that shortly. There are two other formulas that return the same error, one doesn't have an "AND". They are:
>(date()-730) and <date()+730
and
>="Fri Jan 01, 2010"
Any suggestions!
Thnx a mil, I really appreciate it.
Hey!
Here's a good one for you!
I’ve added several fields to a straight forward Access dB with a single data table. Once the new fields are added, Access decided it doesn’t like a formula in an unrelated date field and I get an error message that says "the expression you entered has an...