I am working on a Biggest Loser competition at work. I'm entering the date and weight in a form and saving it to it's own table. Then I query that data and print it on a report. It was pretty easy to get the date in the right order and output the weights. What I would also like is to display the change since their last weight. I am not storing this in the database, I suppose I could, but it seemed better to calculate it when needed, i.e. in case I made a data entry error and needed to edit a weight. I suspect this is not easy.
This is how I'd like it to look.
Date Weight 11/1/2015 220 11/5/2015 218 -2 12/1/2015 218 0 12/22/2015 219 1 1/5/2016 215 -4
This is what the (early draft) report looks like. It's in Access 2016.
Any guidance is appreciated! And please be gentle, I'm an Access beginner.