Query help to for min date with
Posted on 2011-02-10
I have one table ... (simplified here) .... 3 columns:
PLOT_VISIT_CN PLOT DATE
1 Big_Sagen 1/1/1997
2 Big_Sagen 2/3/2001
3 Little_Boy 1/1/1997
4 Little_Boy 7/23/2002
5 Little_Boy 8/24/2003
I'm trying to write a query to show the minimum date but I need all three fields.
When using only Plot and Min(Date) ... looks good, but when add PLOT_VISIT_CN the rows are unique so I get them all.
Trying to join the table on itself without much luck. I should know how to do this but cannot get it to work ... appreciate any help.