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.

  • autopath
  • field
  • hard drive

    A hard drive is a device that save a large quantity of data for later recollection.

    Most hard drives today use a magnetic system to save the data. However, those do get really hot and tend to break easily because they use a mechanical head (after 4 to 5 years.) Yet, they have an incredible capacity with drives that can hold as much as 2Tb.

    New modern drives use flash technology. This is like your USB thumb drive. It does not get hot, it is silent, it has much faster read access (no head to move.) It has two drawback: (1) it has a rather slow write and (2) the capacity is still quite small (at time of writing we are starting to get 128Gb drives...) The price is also much higher, but if you consider that these drives will probably last you twice as long as the magnetic drives and you won't need extraneous cooling systems, overall, it probably still worth it.

  • insert
  • OS