If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Displaying the contents of a report in an order
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 |
#3
|
|||
|
|||
Displaying the contents of a report in an order
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 |
Thread Tools | |
Display Modes | |
|
|