Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Report Order (XP SP3 Access 2003)

    I must be getting senile, as I can't figure out what's going on. I have a query that displays data in alphabetical order by name. I have a report that uses that query as its data source. However, the report doesn't come out in that order. In fact, I can make no sense of ther order it does report -- kind of random although it could be in something like the primary key order. This one really has me puzzled.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Report Order (XP SP3 Access 2003)

    Reports don't 'inherit' the sort order of their query.

    You need to specifically set the order in the Report, using the sorting and grouping dialog.
    Regards
    John



  3. #3
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Order (XP SP3 Access 2003)

    Thank. That did it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •