Last Visit Date in Table of Multiple patient visits

[jpvonhemel]

I have a table that has multple visits for multiple patients. The account number is unique to the visit, PT ID unique to the patient. I am needing help writing a query that returns the records with the LAST AdmitDate for EACH PT ID. I am not sure how to proceed. Evaluating the date between multiple records is confusing me. I would appreciate any direction to accomplish this. I attached a sample showing the basics of how my table is formatted.



Thank you very much,

Jerold

[pbaldy]

Does this fit?

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

[jpvonhemel]

Yes, I think maybe it will. Thanks. I'll see what I can come up with.

[pbaldy]

No problem; post back if you get stuck.