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
|
|||
|
|||
Sub-report sorting problem
Hi
I created a sub-report to include some notes from a notes table into my League report It uses the following: SELECT DISTINCTROW tblnotes.ID, tblnotes.Yearfld, tblnotes.Notefld FROM tblnotes ORDER BY tblnotes.ID; However, when I do a preview of the report, it is not sorting by ID For example, the last two notes (items 31 and 32 from tblnotes) come out in the order 32, 31 !! This is quite important, as line 31 states 'National League 3 notes' and 32 states notes on teams What might be wrong? Thanks Neil |
#2
|
|||
|
|||
Sub-report sorting problem
Open the subreport in design view, and use the sorting and grouping pane to
specify the sort order. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. " wrote in message ... Hi I created a sub-report to include some notes from a notes table into my League report It uses the following: SELECT DISTINCTROW tblnotes.ID, tblnotes.Yearfld, tblnotes.Notefld FROM tblnotes ORDER BY tblnotes.ID; However, when I do a preview of the report, it is not sorting by ID For example, the last two notes (items 31 and 32 from tblnotes) come out in the order 32, 31 !! This is quite important, as line 31 states 'National League 3 notes' and 32 states notes on teams What might be wrong? Thanks Neil |
#3
|
|||
|
|||
Sub-report sorting problem
On 2 Apr, 13:10, "Allen Browne" wrote:
Open the subreport in design view, and use the sorting and grouping pane to specify the sort order. -- Allen Browne - Microsoft MVP. *Perth, Western Australia Tips for Access users -http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. " wrote in message ... Hi I created a sub-report to include some notes from a notes table into my League report It uses the following: SELECT DISTINCTROW tblnotes.ID, tblnotes.Yearfld, tblnotes.Notefld FROM tblnotes ORDER BY tblnotes.ID; However, when I do a preview of the report, it is not sorting by ID For example, the last two notes (items 31 and 32 from tblnotes) come out in the order 32, 31 !! This is quite important, as line 31 states 'National League 3 notes' and 32 states notes on teams What might be wrong? Thanks Neil- Hide quoted text - - Show quoted text - Thanks - now why did I not spot something so obvious! Neil |
Thread Tools | |
Display Modes | |
|
|