Qry to accumulate values doesn't work?!?

[Steff_DK]

My table has a list of calculated values corresponding to a date.

I need my query to sort by date/time and accumulate the values.

Pls see the simplyfied attached db with the table and query.

I can't see what could possibly be wrong with it
It works fine when I accumulate non-calc'd values e.g. the record ID ..

 

[Len Boorman]

Try leaving the accumulations out of the query calculating values

Use a new query to query your original query to sort and accumulate

Len