query/report
in [Reports]
|
From: patti on 21 Feb 2010 20:43 I have a query that sorts correctly on ClientNo field. Report based on that query has different sort; why would this be?
From: patti on 21 Feb 2010 20:47 I created a new report based on the query and that report was fine. So why does the original report not work? Access 2003. "patti" wrote: > I have a query that sorts correctly on ClientNo field. > Report based on that query has different sort; why would this be?
From: Allen Browne on 22 Feb 2010 01:16 In report design view, use the Sorting And Grouping pane to specify how you want the report sorted. This is much more reliable than hoping the report will sort as the query does. In general, there's no point sorting the source query for a report. -- 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. "patti" <patti(a)discussions.microsoft.com> wrote in message news:B1A1049E-389A-4E51-98C9-2205A3C6CC03(a)microsoft.com... > I created a new report based on the query and that report was fine. So why > does the original report not work? > > Access 2003. > > "patti" wrote: > >> I have a query that sorts correctly on ClientNo field. >> Report based on that query has different sort; why would this be?
From: patti on 22 Feb 2010 23:43 Thanks Duane and Allen. "Allen Browne" wrote: > In report design view, use the Sorting And Grouping pane to specify how you > want the report sorted. > > This is much more reliable than hoping the report will sort as the query > does. In general, there's no point sorting the source query for a report. > > -- > 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. > > > "patti" <patti(a)discussions.microsoft.com> wrote in message > news:B1A1049E-389A-4E51-98C9-2205A3C6CC03(a)microsoft.com... > > I created a new report based on the query and that report was fine. So why > > does the original report not work? > > > > Access 2003. > > > > "patti" wrote: > > > >> I have a query that sorts correctly on ClientNo field. > >> Report based on that query has different sort; why would this be? > > . >
|
Pages: 1 Prev: Data split on pages Next: Printing Access 2007 Reports on an A5 Paper |