A
Access Joe
Hey all,
Is there a way to find / fitler by the most RECENT date entry. I.E. I have
the following data set:
ID DATE
1 12/2/2006
1 12/7/2006 (this is the date I want displayed for THAT patient ID)
2 4/6/2007 (this is the date I want displayed for THAT patient ID)
2 7/7/2006
3 9/9/2007
3 8/7/2007
3 9/10/2007 (this is the date I want displayed for THAT patient ID)
You see, each patient comes in on different dates. What I need to see and
analyze are JUST those dates for each patient that were the most recent. Is
there a way to perform a filter that does this?
Thanks!
Is there a way to find / fitler by the most RECENT date entry. I.E. I have
the following data set:
ID DATE
1 12/2/2006
1 12/7/2006 (this is the date I want displayed for THAT patient ID)
2 4/6/2007 (this is the date I want displayed for THAT patient ID)
2 7/7/2006
3 9/9/2007
3 8/7/2007
3 9/10/2007 (this is the date I want displayed for THAT patient ID)
You see, each patient comes in on different dates. What I need to see and
analyze are JUST those dates for each patient that were the most recent. Is
there a way to perform a filter that does this?
Thanks!