Grouping and Sorting question

  • Thread starter Thread starter David
  • Start date Start date
D

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
 
David said:
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
Click to expand...


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.
 
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.
 
Back
Top