Recent content by jethomas930

  1. J

    old query doesn't like new fields

    Thnx, so much, I really appreciate it -- didn't realize how rusty I am. And all your formula's work!
  2. J

    old query doesn't like new fields

    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.
  3. J

    old query doesn't like new fields

    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...
Back
Top Bottom