Unanswered: How do I find the last record based upon a date?
I have fields:
PID, DatePerformed, NumResult
I'v tried totals queries, but that yields weird results. When I try to select the max date and group by the PID, that is fine, however when I cascade the next query, it gives me the maxdate, but gives me all the NumResults with the last date (incorrectly-the actual date is changed to the max date).
What is the most accurate way to get the last result for each PID? this is patient labs.