Using MAX(): How to include next parameter...

[davelarue]

Using the MAX(): i searched internet and found a tutorial. databasedev tutorial

from this tutorial, how do i include strProductName in the query?
This is an example, and i am doing the same for another report which has 10000 entries. If i just include strProductName in the query, then i don't get the correct amount of 'last order date'

Thanks for your help!

Dave

 

[jdraw]

We have no idea where strProductName fits.
Please provide some context if we are to help you.

 

[davelarue]

In this tutorial http://www.databasedev.co.uk/access_max_function.html
- I want to add a third column in the result above (pic) = strProductName (name of the product). Any ideas how i do this?
Thx,
David