Grouping Certain Records Together

G

Guest

Hello - newbie here.

I have created a report and it prints out in order by Company Name (A to Z).

The report works fine.

However, we have a field called Status and some of the records have the
Status of "Closed". How can I print out all the Statuses that are "Closed"
at the end of the report. I still want to keep it in order by Company Name,
but want all the closed records grouped together at the end of the report.

Thanks !

Ty
 
D

Duane Hookom

Set up you primary level of Sorting and Grouping as
=([Status]="Closed") with an order of descending
Then order by other fields/expressions
 

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