How to display records in ascending order on a report
in [Reports]
|
Prev: How to submit a access report in HTML format
Next: * Free Library management & membership software *
From: questy on 8 Jul 2008 02:31 Hi I have a report that dsiplays query records. I am running this query in ascending order of a Field. But the report is not dsplayed in the same order as query. Any suggestions on how I can correct this ?
From: Allen Browne on 8 Jul 2008 03:05
Open the report in design view. Use the Sorting And Grouping box to define which fields you wish to sort by. As you found, the sort order for the report is not necessarily the same as the sort order for its source query. -- 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. "questy" <questy(a)discussions.microsoft.com> wrote in message news:65A5F4B2-8975-44C3-B3C7-60693D757152(a)microsoft.com... > Hi I have a report that dsiplays query records. I am running this query in > ascending order of a Field. But the report is not dsplayed in the same > order > as query. Any suggestions on how I can correct this ? |