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

Signature
Terry Kreft
> 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 ?