I try, and first get "DATUM is not unique and must be qualified" error.
I changed

(Select kilometri.ID, datum, kilometri.stanjekm AS Km;

to

(Select kilometri.ID, kilometri.datum, kilometri.stanjekm AS Km;

and voila!!! Thats it!!!

Thanks a lot for your help!

>OOO!
>I didn't understood that you want KM for MAX(date) not MAX(km). Try this:
>

>Update RptTjedniKm ;
>	Set Startkm = Kmtr.Km;
>FROM RptTjedniKm;
>INNER JOIN (Select kilometri.ID, datum, kilometri.stanjekm AS Km;
>                   From kilometri;
>                   INNER JOIN (SELECT ID, MAX(datum) AS datum;
>                                      FROM kilometri;
>                                      GROUP BY Id WHERE datum < ldDatod) Klmtr;
>                   ON kilometri.Id = Klmtr.Id AND kilometri.Datum = Klmtr.Datum) Kmtr;
>ON RptTjednikm.ID = Kmtr.ID
>

>(not tested)