Sorting in a summary report


S

simon

I have created a summary report(no detail) that indicates
% loss in 22 regions. It currently automatically ranks the
data in region order. Is it possible to change this and
have the report ranked in the loss % field.
 
Ad

Advertisements

K

Kurt

I have created a summary report(no detail) that
indicates
% loss in 22 regions. It currently automatically ranks the
data in region order. Is it possible to change this and
have the report ranked in the loss % field.
Open the report in Design View and go to View | Sorting &
Grouping. Under Field/Expression, select your percent
field. Under Sort Order, select Ascending.

Kurt
 
Ad

Advertisements

D

Duane Hookom

You can only sort by values in the report's recordsource. If the % isn't in
the record source, you will need to either convert you query to a totals
query or combine it with a totals query.
 

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

report summary 1
Summary of Hours in a Report 2
Yearly Sales Report Summary 7
summaries of summaries.. 1
Summary 1
system summary 1
summary query 5
Summary Table 0

Top