Grouping and Sorting question

[David]

I have a query that returns client id's, account #'s, and account
values. One client can have multiple account #'s. My query is sorted
by account value descending. My results look similar to this:

Client ID Account # Value
1 1234 1000
2 9999 999
1 4321 900
2 7777 800

I want my report to group by the Client ID, but still order by the
value. So my report should look like this:


Client 1
Account # 1234 Value 1000
Account # 4321 Value 900

Client 2
Account # 9999 Value 999
Account # 7777 Value 800

I could use some insight as to how this can be accomplished.

Thanks,

David

 

[Marshall Barton]

I have a query that returns client id's, account #'s, and account
values. One client can have multiple account #'s. My query is sorted
by account value descending. My results look similar to this:

Client ID Account # Value
1 1234 1000
2 9999 999
1 4321 900
2 7777 800

I want my report to group by the Client ID, but still order by the
value. So my report should look like this:


Client 1
Account # 1234 Value 1000
Account # 4321 Value 900

Client 2
Account # 9999 Value 999
Account # 7777 Value 800

For reports, the sorting in the query is overwritten by the
Sorting and Grouping list. Open the report in design view,
the use the View - Sorting and Grouping menu item to display
the list. Put the ClientID field first on the list and teh
account number on the second line.

 

[Duane Hookom]

It looks like you only need to sort/group by Client ascending and then Value
descending. Keep in mind that sorting in your query is worthless. Use the
sorting and grouping in your report design.