DSUM i Rapporter

Make sure that the table/query you use in the reports records source and also in the dsum are the same.

"Dieselforbrug alle data"

I think somewhere along the line we may be using two similar queries but only one of them has the between criteria.

The dsum has to use the same source to give same result.

If you are using the same query then a bit more information as to the error is needed.

Hej.
Rapporten henter sine data fra samme forespørgsel hvor beregningen af kørt KM foretages med:
KM Kørt: [KM]-(SELECT  max(KM) from dieselforbrug where dieselforbrug.ID < DF.ID)
I dato har jeg indsat kriteriet;
Between [Startdato xx-xx-xxxx] And [Slutdato xx-xx-xxxx]
I rapportfoden har jeg: =DSum("[Pris]";"[Dieselforbrug alle data]")
I summen står der #fejl
Jeg skal bruge en sum for forskellige dato intervaller

Not sure what you mean here

"I dato har jeg indsat kriteriet; Between [Startdato xx-xx-xxxx] And [Slutdato xx-xx-xxxx]"

Is this in the query or somewhere else? If it is in the query used in the reports record source, and the same query is used in dsum then it should work.

Maybe you should send me the newest dB so I can take a look.

I have changed query to use dmax() rather than max(), so now you can use sum() rather than dsum().