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 :-)