Results 1 to 4 of 4
  1. #1
    Join Date
    May 2014
    Posts
    98

    Unanswered: Query display ID in asceding order However Report doesn't

    I have tried making ID in query of the Report as Ascending and also I tried Order by as ID [ASCE] but neither is working and display all ID in ascending order. Few of ID are in ascending order in Report whereas others are not

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    the report sort order overrides the underlying query sort order. so check what sort order you have specified in sorting and grouping for the report
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2014
    Posts
    98
    I tried Grouping and sorting but it didn't worked Still shows non sorted ID

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Is the ID Field actually defined as a Number Datatype?

    A Text Field, that contains only digits does not Sort as it would if it were actually a Number Field.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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