Beregning af kørte KM

something like this

SELECT tblKm.[Reg-nummer], tblKm.afldato, tblKm.[KM stand], [KM stand]-(SELECT TOP 1 [KM stand]  FROM tblKm K WHERE tblKm.[Reg-nummer] = K.[Reg-nummer] and K.[afldato] < tblKm.[afldato] ORDER by [Reg-nummer], afldato ) AS korteKM
FROM tblKm;

Hi Terry,

I tried to modify your suggestion to meet my needs. It doesn't work quite as i required.

What I need is a solution, where individual km-readings on all cars, returns the mileage (km) driven since the last km-reading.

What to do?

The modified statement looks like this:

SELECT kilometer_registrering.[lobe nummer],

kilometer_registrering.[afldato], kilometer_registrering.[km stand],

[kmstand]-(select top 1 [kmstand] FROM kilometer_registrering K

where kilometer_registrering.[lobe nummer] = K.[lobe nummer] and K.[afldato] < kilometer_registrering.[afldato]

order by [lobe nummer], afldato)

as korteKM

from kilometer_registrering;

could you send a copy of the dB (tables) and I'll put some SQL together for you

ekspertenATsanthell.dk
AT = @

?

are we getting there?

Hey Terry,

Sorry for late reply. Vacation.

I'll send youi an email shortly.

Regs.
Anders