min value

[pit]

i need to show the the corresponding date field that matches the min value of
another field. is this possible?
thanks for any help.

 

[Allen Browne]

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.

 

[pit]

Thanks Allen-

now i'm cooking

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.