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

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

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