beregning af forskel i km

SELECT tblMileage.id, tblMileage.Date, tblMileage.Odometer, DLookUp("[Odometer]","tblMileage","[ID] = " & [ID]-1) AS [Previous Odometer], tblMileage.Gallons
FROM tblMileage;


This is ONLY an example, which I am sure you can see how it works!

You need to refer to the previous records autunumber field, in this case there are NO missing records so it workd fine, but IF you have deleted records then you will need to get the HIGHEST ID which is less than the current!

can you give an example of which fields you have, and also what you want to see in the result.

do you want help here?

xfiles>If you want help then it would be nice of you to give some feedback, this is a two way thing!

Hi Terry

Thank you for helping me out on this. Your tip solved my problem. Mvh. Xfiles

you need to accept the answer then :o)

are we there?

.

.

Hvordan afslutter jeg et spørgsmål ?

you accept one of the answers given. Mark the name in the list and accept.

status?

thanks xfiles!

Løsningen på KM beregningen blev:
KM Kørt: [KM]-(SELECT  max(KM) from dieselforbrug where dieselforbrug.ID < DF.ID)

Løsningen på en total sum i Rapporter blev:
=DSum("[Pris]";"[Dieselforbrug alle data]")

Når jeg så indsætter:
Between [Startdato xx-xx-xxxx] And [Slutdato xx-xx-xxxx]
Som kriterier i forespørgslen, for at filtrere i datoer, får jeg fejl i =DSum.....

Now I'm puzzled!

User who created this question was "xfiles" but now Klodshans who has a similar question http://www.computerworld.dk/eksperten/spm/1014638 places a comment with answer here!

Anyway, I think we need to close the other question (http://www.computerworld.dk/eksperten/spm/1014638)

and then create a new question.