Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What I don't understand, with the attached Query1 query, is that the top three rows of its output display SCRM in the Utente column in spite of the fact I've set
    ORDER BY Mag.SerialNumber, Mag.Visto DESC , Mag.Rich DESC , Centri.Nome;
    Why doesn't the Utente column follow the sort order?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Although the Rich field (labeled Utente) displays the UserName field from the Utenti table, it is a number field that is linked to the Room ID field in Utenti. So you're actually sorting on this number field. You can add the UserName field to the query and sort on that instead.
    SCRM will still be listed first because you sort descending.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you Hans, can you please try and open the attached Query1 Report, which is based on the same data?
    I get the message that the record source of the report doesn't exist.
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The row source of the UnMis combo box refers to something that doesn't exist.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you Hans, why does the Query1x query sorts correctly by UserName while the Query1 report(which is based on Query1x) doesn't?
    Attached Files Attached Files

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='grovelli' post='767259' date='25-Mar-2009 15:23']Thank you Hans, why does the Query1x query sorts correctly by UserName while the Query1 report(which is based on Query1x) doesn't?[/quote]

    The sort of the report is based on Rich and not on UserName, like Hans explained in Post 767228.
    A report take his sort from the Sort and Grouping window and not from the recordsource.
    In the Sort and Grouping wondow replace Rich by UserName
    Francois

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [

Posting Permissions

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