Re: alphabetic sort problem

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

One more thought, why does the sort work in the query grid using the A-Z
sort button?

Steve
"Marshall Barton" <marshbarton@xxxxxxxxxx> wrote in message
news:5qbhn2peov3ihc6e3rdptm8ako2vr71ug2@xxxxxxxxxx
Good eye's Van, I never saw that. Just goes to show how a
single word can be the most important clue.
--
Marsh
MVP [MS Access]


Van T. Dinh wrote:

I think the tiny hint of the cause is the word "report" in your sentence:

[quote]
This is the way the report sorts with location selected to sort ascending
(wrong sort):
[unquote]

The Report processing ignores the sorting (ORDER BY clause) in your Query!
Records / rows are retrieved randomly (to us) as Access/JET sees fit so
records / rows retrieved can be in any order ...

If you want to sort in the Report, you need to use the "Sorting and
Grouping" feature of the Report (more flexible) or the [Order By] and
[Order
By On] Properties of the Report (less flexible).





.

Relevant Pages

  • RE: Sorting Dates
    ... If you want to sort on the date field, it should be a date data type. ... sorting or using in calculations. ... I am trying to re-do the report as we speak. ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: "Convert in Integer" for MA or any guru, please!
    ... I thought you only wanted to sort the report by this value. ... in the sorting and grouping expression/field. ...
    (microsoft.public.access.reports)
  • Re: Selecting records matching user input
    ... Report order is controlled by the Sorting and Grouping dialog of the report. ... What I meant by SOMETIMES the sort order of the query works is just that. ... I have removed everything from Grouping and Sorting and now ORDER BY in my SELECT query is working as it should. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sorting by complex alphanumeric data
    ... sort as though it were a true Year. ... I didn't know that you could write statements into the sorting and grouping ... most likely could use in the Report Sorting & Grouping what I gave you above ... The first one characters are always letters. ...
    (microsoft.public.access.reports)
  • Re: Report in FM 6 or 7
    ... Please adivse on this- and then, I get to attack this report again in ... you cannot sort by AgeDivision_Category and why the Export/Import ... act they want to be the last act of the show, they have to sort by their ... If the Age Division field contains data in the form "3-5 Age Division" ...
    (comp.databases.filemaker)