Field values associated with Min or Max value in Group by Totals Q

C

Catchy

MS Access Database (Office Professional 2003)

When obtaining a minimum ("Min") or maximum ("Max") value for a group of
records obtained through a Select Query I am unable to obtain the date that
relates to the specific Min or Max value. For example in Totals row of Grid
Pane specify "Group by" for fields Country, Region and Area. Specify "Min"
(or "Max") for numeric field such as Sales. I cannot find a way to extract
the date associated with the Min or Max Sales value ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Min/Max Dates and Group By 2
Group By, Max and Min 2
Group by query question 2
return fields associated with max value record 9
Min and Max for Date Range in Report 4
formula to display the max (or min value) for an entire column, basedon value in an individual cell 1
Group By, Max, many to many 1
Flag a value in a group... 4

Top