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

Top