Displaying the contents of a report in an order

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

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.



--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


"Dave B" wrote in message
...
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

Hi Cheryl

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

--
Cheers
Van T. Dinh
MVP (Access)




"Cheryl Fischer" wrote in message
...
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.



--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX