Adding something in reportfooter changes sorting

J

Jean-Paul

Hi,
This is very strange
I create a report without reportheader/footer based upon a query.
This query sorts the recordset upon "reference"
The sorting is perfect, the report too (almost ;))

I add a reportheader/footer
I the footer I add a field: = sum([OPay])

The sum is perfect but, the sorting in the report details is gone.

I delete the field in the footer... sorting perfect

How is this possible? and what can I do about it?

Thanks
JP
 
A

Allen Browne

Use the Sorting And Grouping dialog to define the order of records in the
report.
 
Top