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?