AnsweredAssumed Answered

Value between two records of the same table

Question asked by danjherbert on May 9, 2017

I have a table where I want to calculate the value between two records, where the field 1 - field 2 gives me the result in field total

 

The table is made up of the following fields

 

id = unique / auto-enter

date = date of the Monday of the week

mon_gross = number

fri_gross = number

total = calc

 

each week a record is created and the Monday and Friday values are entered, I want the total to show the difference between the Friday of the previous week and the Monday of that week

Outcomes