Grouping question

[MelaniSommers]

Hi,

I have a simple sales list (salesperson, salesamount, and
salesdate).

I've created a grouped query by sales person, and used
the max on the Sales amount coloumn. This gives me the
highest sale by Sales person.

I'd like to see the salesdate (or one of them) that
corresponds to the highest sale amount. I'd like to do it
in one query. None of the options Group By, Last, First
work when I add the SalesDate to the grid.

Anybody know how to do this (in one query preferably)?

Thanks in Advance

Melani

 

[Joan Wild]

Look at www.mvps.org/access in the queries section, you'll see
Getting a related field from a GroupBy (total) query
which has a single query solution.

 

[Guest]

Hi Joan,

Checked out the website you suggested www.mvps.org/access
and found the answer I was looking for.

thanks