Difficulty with Finding Records
I apologize if this has already been addressed in previous posts. I checked but had negative results (probably due to inaccurate key words). Please direct me as necessary.
I have a medical table containing approximately 2000 records. One person may have numerous entries for past medical check-ups. I the "relationships" section of the "Manage Database" window, I have sorted the records by date in descending order.
If many people have many records, how can I find only those who haven't had an entry for more than one year?
Thanks for your time,