0

I am working with Access, dated I know but it is what I have. I am dropping payment information into a table so I have multiple entries for each person. All I want is a way to show the most recent entry for each patient and I way to mark them as current or delinquent. I have been doing this manually but there must be a better way. And I then need to pull reports off of those numbers.

Help!

I have tried a Max Query but then I cannot type in the query boxes and thus the point is defeated.

Kira Tucker
  • 1
  • What determines delinquent? – June7 Nov 21 '22 at 19:03
  • 1
    Does this answer your question? [Top n records per group sql in access](https://stackoverflow.com/questions/41220690/top-n-records-per-group-sql-in-access) – June7 Nov 21 '22 at 19:04
  • 1
    Also https://stackoverflow.com/questions/74524646/msaccess-query-to-return-result-set-of-earliest-rows-with-a-unique-combination/74525068#74525068 – June7 Nov 21 '22 at 23:59

0 Answers0