Yes



>Only records with apd.ddate = vp_date should be updated, right?
>
>>Just !
>>VP_date - 1
>>
>>
>>>>I want for each day put the stock of medicament.
>>>>
>>>>
>>>

>
>>>>AGENDA.DBF
>>>>*--- NAME             MEDICAMENT     DATE          CONSOMMATION      STOCK
>>>>Ex : MILCENT bernhart TEMESTA 2.5    14/03/2007    1                   50 ( Before )
>>>>MILCENT bernhart TEMESTA 2.5    15/03/2007    1                   49 ( Before )
>>>>
>>>>TRAITER.DBF       STOCK ( BEGINNING )
>>>>IRESIDENTID           50
>>>

>>>>
>>>>FOR 14/03/2007 IF NO MEDICAMENT for 13/03/2007 Take stock Of traiter.dbf ...( 50 ).
>>>
>>>Than condition apd.ddate < vp_date is incorrect because it'll pick up all previous record but you want only the latest one before current, right?