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.


"neil40@btinternet.com" <neil.grantham@googlemail.com> wrote in message 
news:b0cb2504-4248-401e-9b3f-a3caa524f863@w17g2000yqj.googlegroups.com...
> 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" <AllenBro...@SeeSig.Invalid> wrote:
> Open the subreport in design view, and use the sorting and grouping pane =
to
> specify the sort order.
>
> --
> Allen Browne - Microsoft MVP. =A0Perth, Western Australia
> Tips for Access users -http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "nei...@btinternet.com" <neil.grant...@googlemail.com> wrote in message
>
> news:b0cb2504-4248-401e-9b3f-a3caa524f863@w17g2000yqj.googlegroups.com...
>
>
>
> > 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