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.

  • Gb

    Giga bytes--these days, the common measure for memory and disk space. It changed in the last 20 years from Kb (Kilo bytes) to Mb (Mega bytes) and to Gb. With disks, we are close to Tb (Tera bytes) and some people talk about Pb (Peta bytes).

  • key

    There are several ways to use the term key in software development. You may have heard it a lot in regard to public and private keys. Those are used to encrypt and decrypt data sent over the wire. Another way is when you want to sort a large number of entries in a database. In that case, you most likely will need a unique key. For example, a page on the Internet is defined with a URI. You may define a canonical version of that URI making it unique. That canonical version is called a key for that page.

  • pg_connect
  • sha256
  • tripwire