Query first record from each group

[Cliff]

I am doing a Biggest Loser challenge at work and have a nice report that shows the users their weight loss over time. I'd also like to add a table that shows the group's starting weight and the group's current weight.

I have one simple weights table that lists the ID of the contestant, the date and the weight.

How can I query / sum the first weight from each contestant, and also the last weight? I suspect this is not easy.

I am a relative beginner using Access 2016.

Thanks

 

[MarkK]

In a query you can select the first record using the SQL TOP keyword, like . . .

SELECT [COLOR="Blue"]TOP 1[/COLOR] * FROM Table ORDER BY Field1

To select the last record, reverse the sort order and select the first record . . .

SELECT [COLOR="Blue"]TOP 1[/COLOR] * FROM Table ORDER BY Field1 [COLOR="Blue"]DESC[/COLOR]

 

[pbaldy]

You might also be able to adapt this:

http://www.baldyweb.com/LastValue.htm

 

[Cliff]

You might also be able to adapt this:

http://www.baldyweb.com/LastValue.htm

Thank you, this looks like it will work.

 

[pbaldy]

No problem, post back if you get stuck.