Calcualtion with previous and current record

[Chance1234]

Hi

I have a table which looks somethign likt this

Date, Item, Total

I want to calculate the difference between each total compared to the previous days record , mind has gone blank on how to do this

help!

 

[braindead2]

Are you wanting to do this in a report of a Query?

 

[MichaelRed]

Asked and answered recenty. Do a search on "previous records" or "Previoous Record".

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[Chance1234]

Hi what i did in the end was create two querys, the same and changed the names of the columns in one of the tables, then bought the two querys together and in the criteria of teh second date column[idate] i put [date]-1

that worked fine