AnsweredAssumed Answered

Difficulty with Finding Records

Question asked by sulu762 on Jul 20, 2009
Latest reply on Jul 20, 2009 by sulu762

Title

Difficulty with Finding Records

Post

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.

 

 

Situation: 

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.

 

Question:

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,

 

Sulu 

 

 

Outcomes