Syndicate content

MS-Access query sort not working

Looked around on how to sort out a report properly as it was sorting on the wrong field (actually at first it did not even look like it was sorted at all, but I did not notice that other field was indeed sorted!)

The sort in a Query Report form (opposed to just an SQL query) is defined by the Group & Sort feature and not the SQL results. Actually, you most certainly don't need it in the SQL because otherwise you'll be sorting twice.

It took me a while, but I'm glad I found the solution. All the documentation I searched only talked about the wrong methods: use the Query sort field, use a Filter, use an Order By... none of those worked. They all are overridden by the Group & Sort feature of the Query Report form.

Although the sort is limited (i.e. does not offer you a way to sort by fields that are not marked as visible, or are from a table other than the main table), it generally works as expected once you use that feature.

Source: http://www.tek-tips.com/viewthread.cfm?qid=825427

Syndicate content

     

Terms of Site Index

Find the page/content you are looking for with our index.

  • complex
  • demonstration
  • QODBC

    ODBC driver for QuickBooks

  • radio

    In the computer world, the term radio is often used for radio buttons.

    Radio buttons are a group of seletable buttons, however, only one of the buttons can be selected in a group. This is called an exclusive choice. Programmatically, when the end user clicks on a button, the computer makes sure that all the other buttons are de-selected.

    The result of the selection is often a number representing the selected button.

  • zlib

    The Z library is a compression library based on an algorithm that compresses at best in some automated and simle way. For better performance, the entire input file is necessary. Note that you can get better results with other methods, this one is excellent for streaming, however.