about group by query

[rudwan]

hi
i have a table contain :
CustID long
InvDate Date
InvAmount Currency
Shipped boolian
i designed grouped by query to give me last invoices for
each customer like this :
CustID groupby
InvDate Max
who i can bring invamount & shipped from the same query

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

The article offers 4 alternatives.