Report sorting (when I don't want it to)

[TOPSie]

I want to produce a report of a customer's transaction history. So I prepare a temporary table which contains the transactions for a particular customer for a given period.


The table contains a field containing ther transaction date and a few more fields with details of the transaction. The temporary table is created with the newest transaction first and all other records with date descending.

The table is used as the Record Source of the report which is simply temporarytable.* with not further filtering or sorting.

But when the report prints the records start with the oldest and further records with sdate ascending.

I just don't know why this is happening as the report should just read the temporary table???

[TOPSie]

Please ignore this thread - I have found the solution. I needed to access the Report's Group By pane - all sorted now.
Apologies I am still obviously a novice :-)