Re: sorting question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

jlute@xxxxxxxxxxxx wrote:

Sorting a query is mostly useless for reports.  Use the
report's Sorting and Grouping to sort the report's records.


I see I wasn't very clear. I meant to say that the query sorts
ascending NOT because it has a sort order but because the ID is the
primary key and therefore automatically sorts ascending.

I took another look at the subreport and sorted [ShortAddress]
descending so that any ID's with null values are shoved to the bottom.
This enables the text box to properly appear however the ID's are
thrown out of order. To resolve that I sorted the ID's ascending. This
results in the ID with a value in [ShortAddress] to be first followed
by all other ID's in ascending order which is not exactly what I'd
like.

This seems impossible to resolve. I'm back to square one:
The text box displays properly ONLY if the FIRST record in the
ascending order contains a value in [ShortAddress].


Where is this text box? It sounds like it's in the report
(or page) header. I would expect it to behave if it were in
the detail section.

The sorting issue still needs to be addressed. You can not
rely on the query sorting without using the Ordery By
clause. And even if you do that, the report will very
likely ignore it. From your explanation, you should specify
the ID field at the top of the report's Sorting and
Grouping.

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: Command button to change sort order in list
    ... click on the button the sorting is always in Ascending order. ... click on COUNTRY it will always sort asc and not desc, ... Trying to add a button to a column header (The button will be transparent) ...
    (microsoft.public.access.forms)
  • Re: Cant sort by date
    ... >> How can I sort a spreadsheet by a column full of dates? ... >> make sense of the order even assuming it is sorting like text. ... because it changes when I switch between ascending and ... >> descending. ...
    (microsoft.public.excel.newusers)
  • RE: Sorting Dates
    ... All would be in ascending order. ... my 3rd sort is by seniority Date. ... This report is an overtime callout sheet ... How would I go out about sorting the Seniority date properly? ...
    (microsoft.public.access.reports)
  • Re: Sort by Date
    ... Ascending then =Month, Ascending and it gave me what I ... My report is built from a query that was set up to show the sum of each ... You need to sort a report in the report's Sorting and Grouping dialog. ...
    (microsoft.public.access.reports)
  • sorting number in ascending order
    ... It came as ="number" format when I exported to excel. ... When I tried sorting this field in ascending order, however, it didnt' sort ...
    (microsoft.public.excel.misc)