Search results

  1. E

    Exceptionally simple update query not working

    My update query updates a currency field by subtracting £5.00. The criteria is based on a customer's date of birth field, and I use: <#31/12/1950# I have also tried YY/MM/DD. Basically, it works, but if a customer has a DOB on any date/month in 1950, it wont, and that makes no sense...
  2. E

    Basic Question on a (Fairly) Basic Query

    Hi, Could any Access experts let me know if this is possible, and how it would be achieved: 1. I have an update query. 2. It updates the costs of treatments by a reduction of £5.00 (criteria is in DOB field <=#01/01/1950#) 3. I have a field that says: "Discount Applied?" - My...
Back
Top Bottom