MaxKm is a field of derived table, result of this query:
INNER JOIN (Select kilometri.ID, Max(kilometri.stanjekm);
From kilometri;
GROUP BY Id WHERE datum < ldDatod) Kmtr;


>Hmm. what is Kmtr.MaxKm??? SQL and I are confused :))
>
>>>Hi!
>>>
>>>I have table kilometri with 3 fields:
>>>ID, datum, stanjekm.
>>>
>>>I want to update another table with stanjekm for max date which is less then some other date...
>>>Here is code which work, but update for max stanjekm. This work, but when someone change km meter in his car, I get wrong result, of course....
>>>How to get stanjekm for max datum, but less then ldDatod?
>>>
>>>

>>>Update RptTjedniKm ;
>>>	Set Startkm = (Select Max(kilometri.stanjekm) From kilometri ;
>>>	where RptTjednikm.ID = kilometri.ID AND kilometri.datum < ldDatod )
>>>

>>>
>>>Branko
>>
>>Try:
>>

>>Update RptTjedniKm ;
>>	Set Startkm = Kmtr.MaxKm;
>>FROM RptTjedniKm;
>>INNER JOIN (Select kilometri.ID, Max(kilometri.stanjekm);
>>                   From kilometri;
>>                   GROUP BY Id WHERE datum < ldDatod) Kmtr;
>>ON RptTjednikm.ID = Kmtr.ID
>>

>>
>>Make a good backup first :-)