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.
Any idea why this criteria would exclude these dates? (I've also tried numerous other ones, including <Date()-23740
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.
Any idea why this criteria would exclude these dates? (I've also tried numerous other ones, including <Date()-23740
Exceptionally simple update query not working
0 commentaires:
Enregistrer un commentaire