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