G Guest Aug 10, 2006 #1 i need to show the the corresponding date field that matches the min value of another field. is this possible? thanks for any help.
i need to show the the corresponding date field that matches the min value of another field. is this possible? thanks for any help.
A Allen Browne Aug 10, 2006 #2 See: Getting a related field from a GroupBy (total) query at: http://www.mvps.org/access/queries/qry0020.htm The article explains 4 ways to do this.
See: Getting a related field from a GroupBy (total) query at: http://www.mvps.org/access/queries/qry0020.htm The article explains 4 ways to do this.
G Guest Aug 12, 2006 #3 Thanks Allen- now i'm cooking Allen Browne said: See: Getting a related field from a GroupBy (total) query at: http://www.mvps.org/access/queries/qry0020.htm The article explains 4 ways to do this. Click to expand...
Thanks Allen- now i'm cooking Allen Browne said: See: Getting a related field from a GroupBy (total) query at: http://www.mvps.org/access/queries/qry0020.htm The article explains 4 ways to do this. Click to expand...
