Adding something in reportfooter changes sorting

[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

 

[Allen Browne]

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

 

[Jean-Paul]

problem solved... thanks