none
Sort order for my list box! RRS feed

  • Question

  • My query shows the correct order I want for my list box. Bot how can I show tblHorseInfo.Invocing in the last column of my list box.............Thanks for any help

    ORDER BY tblHorseInfo.Invocing DESC , qryHorseNameActive.HorseName, qryHorseNameActive.HorseNamed;


    xxx

    Wednesday, August 1, 2018 10:25 PM

Answers

  • SELECT qryHorseNameActive.HorseName, qryHorseNameActive.HorseNamed, tblHorseInfo.Invocing
    FROM …
    ORDER BY tblHorseInfo.Invocing DESC, qryHorseNameActive.HorseName, qryHorseNameActive.HorseNamed;


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by TurnipOrange Wednesday, August 1, 2018 11:01 PM
    Wednesday, August 1, 2018 10:42 PM

All replies

  • SELECT qryHorseNameActive.HorseName, qryHorseNameActive.HorseNamed, tblHorseInfo.Invocing
    FROM …
    ORDER BY tblHorseInfo.Invocing DESC, qryHorseNameActive.HorseName, qryHorseNameActive.HorseNamed;


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by TurnipOrange Wednesday, August 1, 2018 11:01 PM
    Wednesday, August 1, 2018 10:42 PM
  • Thanks Hans ,great

    xxx

    Wednesday, August 1, 2018 11:01 PM