Access subform

[wdisneymom]

I have a form and in it is a subform with student's grades
How can I query this so I can show the last entry only

 

[Ziggy1]

Create a Join Query between the 2 tables. On the View menu click "Totals" (while in Design view) then on the grid area select "Last" under the column for the appropriate field from the "Totals" row.

Ziggy