Footer

C

Chi

Hi,

The report has PCODES header and PCODES footer. I used the textbox to create
the COUNT([PCODES]) at the PCODES' footer.

At the result, I got 3, 4, 2, 1, ....25 ( it counted each PCODE). For
example, the PCODES will be 121213, 121214........121225
EX: PCODE 121213 121214
121213 121214
121213 121214
= 3 121214
= 4
I would like to sort these results so that the biggest number will be
appeared on the top of the report. I would like to see the number 4 on the
top of report and then 3, then 2, 1....
Please help

Chi
 

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

Using Subqueries in an UPDATE Statement 2
Section and Page numbering 0
Sumproduct Question 1
A03 - count in report footer gives me #Error? 0
Creating Different Headers in Word 0
Page numbering with Merged Document and IF statements 1
Weigh tasks 0
Footer On Last Page Only Not Working 1

Top