Calculation in a query from previous record.

[Dorette]

Hi, hoping to find some help.
I am planning a database to calculate weekley weight loss progress. I need to entre the weight every week and then i need to subtract or plus the new entry from the previous entry. I will have a weighDate and weight column. Can someone please assit with the query. Note i do not want a running total, i just want the previous week from the current week.

 

[theDBguy]

Hi. Welcome to AWF!

The principle is the same as a running sum query. You need a subquery to fetch the previous record for reference in the current record.

Take a look here for some examples.

Microsoft Access tips: Subquery basics

Using subqueries in Microsoft Access. What subqueries are, and examples of using subqueries.

allenbrowne.com

 

[jdraw]

Further to theDBguy's response, See in the Similar Threads BY Helmerr Oct 1/2020
Helmerr similar thread example - previous record