Group By

[Galaxy8888]

Use of Group By and Max works well to get records which has max value
of a field within a specific group of records. Now, I would like to
add another field in the query from the selected record which are
selected by Max (and Group By). How do I do this? Say, record A is
selected by Group By and Max. I would like to include field X of
record A in the query with show check-marked. The field X is not
selected for Group By nor for Max.

[Tom van Stiphout]

Re: Group By

On 14 Aug 2004 06:16:20 -0700, galaxy8888@hotm ail.com (Galaxy8888)
wrote:

Create 2 queries.
The first one only has 2 fields like you described: Group By and Max.
The second one has this query, and the table that you want to pull
more data from. Join the two on both the GroupBy field and the Max
field.

-Tom.

[color=blue]
>Use of Group By and Max works well to get records which has max value
>of a field within a specific group of records. Now, I would like to
>add another field in the query from the selected record which are
>selected by Max (and Group By). How do I do this? Say, record A is
>selected by Group By and Max. I would like to include field X of
>record A in the query with show check-marked. The field X is not
>selected for Group By nor for Max.[/color]