Listing "Top Values" first - Help Please

[Adam]

How can i get a report to display the customer with the most points within
his group to show up on top of the group list? (see below)

I have a report that is bound to a query. In that query i calculate how many
points each customer per day. In the query i also calculate the total for
that day. In the report i do a SUM([field that has the days total]) to add up
all the points for all the days totals the customer has. I do this in the
customer ID footer. I group the report by customer type then by customer
code. How can i get the report to display the customer with the most points
within his group to show up on top of the group list?

 

[Duane Hookom]

You may need to create another query similar to your report's record source
but grouped by Customer. Add this totals query to your report's record source
query and join the Customer field. Add the appropriate total to the query to
use in the report's sorting and grouping.

 

[Adam]

understood the first part, but lost me on the second...can you elaborate a
little more? I copied the query reran it and grouped by customer - but i dont
understand what you are saying i should do next...?

You may need to create another query similar to your report's record source
but grouped by Customer. Add this totals query to your report's record source
query and join the Customer field. Add the appropriate total to the query to
use in the report's sorting and grouping.
--
Duane Hookom
Microsoft Access MVP

How can i get a report to display the customer with the most points within
his group to show up on top of the group list? (see below)

I have a report that is bound to a query. In that query i calculate how many
points each customer per day. In the query i also calculate the total for
that day. In the report i do a SUM([field that has the days total]) to add up
all the points for all the days totals the customer has. I do this in the
customer ID footer. I group the report by customer type then by customer
code. How can i get the report to display the customer with the most points
within his group to show up on top of the group list?

 

[Duane Hookom]

Your totals/group by query should sum the points or whatever value you want
to use to sort your report. Once the totals query is added to your report's
record source query, you can use the SumOfPoints in your report's sorting and
grouping dialog.
--
Duane Hookom
Microsoft Access MVP

understood the first part, but lost me on the second...can you elaborate a
little more? I copied the query reran it and grouped by customer - but i dont
understand what you are saying i should do next...?

You may need to create another query similar to your report's record source
but grouped by Customer. Add this totals query to your report's record source
query and join the Customer field. Add the appropriate total to the query to
use in the report's sorting and grouping.
--
Duane Hookom
Microsoft Access MVP

How can i get a report to display the customer with the most points within
his group to show up on top of the group list? (see below)

I have a report that is bound to a query. In that query i calculate how many
points each customer per day. In the query i also calculate the total for
that day. In the report i do a SUM([field that has the days total]) to add up
all the points for all the days totals the customer has. I do this in the
customer ID footer. I group the report by customer type then by customer
code. How can i get the report to display the customer with the most points
within his group to show up on top of the group list?