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

G

Guest

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

Group By, Max and Min 2
Min/Max Dates and Group By 2
Group by query question 1
Sum, Minimum and Maximum with a twist... 2
Crosstab Value field formula too long, min() and max() function help sought 5
Group By, Max, many to many 1
formula to display the max (or min value) for an entire column, basedon value in an individual cell 1
Flag a value in a group... 4

Top