selective update query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create an update query that will that find the difference
between two dates, but will only update if the result is not a minus number.
Any ideas ?
 
Where
tablename is he name of the tabe to update
F1 is the field to update
F2 and F3 are date fields


UPDATE tablename
SET F1 = 'new value'
WHERE (CDbl(F2) -CDbl(F3)) >= 0
 
Back
Top