Displaying the contents of a report in an order

[Dave B]

Hi,

How can i arrange the info that is populating my report in a decending
order. The report shows payments made by a person in increment starting from
the initial amount to the last amount paid. The query that runs the report
is set to decending within the 'sort' and when run display the info in the
order i want(only within the query). Some how between that and the report it
swops round showing the last amount first rather than last.

Thanks in advance,

Dave

 

[Cheryl Fischer]

Dave,

There is no guarantee that the sort sequence in your query will carry over
to the report. To be certain that you do get the sort you want in your
report, use the Report's Sorting and Grouping wizard - there is an icon for
it in the report design toolbar.

 

[Van T. Dinh]

Hi Cheryl

AFAIK, Report processing ignores the sorting in the RecordSource Query
altogether.