How can view the last row in my subform? *picture included*

[yepwingtim]

i made a subform with dates where patients came in for an office visit.

how can i see the last row (lastest date where they came in) of my subform

Note i can't do after, before, between, equal, not equal... because a patient could of came in a last year. I need the lastest date where they came in for visit. Thank you again~

http://img370.imageshack.us/img370/4198/problemfi6.jpg

EDIT:
I have got it up to 1 row with the lastest date but the problem is the reason is not corresponding with the date. If i change the reason back to group by 10 rows will appear again. I want only 1 row showing for each ID.
http://img293.imageshack.us/my.php?i...8147538cf3.jpg
________
Buy Iolite Vaporizer

 

[KenHigg]

In the OnOpen event you could try something like:

SendKeys "^{END}"

 

[yepwingtim]

SELECT Last(EXAMPLE2.ID) AS LastOfID, EXAMPLE2.EXAMPLEID, Last(EXAMPLE2.DATE) AS LastOfDATE, Last(EXAMPLE2.REASON) AS LastOfREASON
FROM EXAMPLE2
GROUP BY EXAMPLE2.EXAMPLEID;

is the closest i gotten... but it sorts the last time i inputted not the lastest date.
________
MAZDA PORTER PICTURE

 

[yepwingtim]

I have got it up to 1 row with the lastest date but the problem is the reason is not corresponding with the date. If i change the reason back to group by 10 rows will appear again. I want only 1 row showing for each ID.
http://img293.imageshack.us/my.php?image=68147538cf3.jpg
________
Hawaii marijuana dispensary