Group field in report by ID order

[eristonmattos]

Good afternoon everyone,
The DB has a form that opens the report according to the date. I put all the objects that make the example work.
The report with data from a query, where I need it to show the record order, but when I group by neighborhood, it returns in alphabetical order, how to solve this?

The DB is this: dropbox.com/s/0g6v2xdtvmqrtod/Relat%C3%B3rio%20modelo2.accdb?dl=0

I hope to be able to count on the members.

 

[Gasman]

Crossposted first at https://www.accessforums.net/showthread.php?t=86389 and solution given

 

[arnelgp]

is this what you meant.
https://www.dropbox.com/s/guqogg9poma5lgx/Relatório modelo2.zip?dl=0

 

[eristonmattos]

The report has the structure the way I need it, but it's not showing the neighborhood field in the order of registration, take a look

 

[The_Doc_Man]

First question, related to this in your post: The report with data from a query, where I need it to show the record order, but when I group by neighborhood, it returns in alphabetical order, how to solve this?

Are you attempting to perform the GROUP BY in the query?

For reasons not totally understood, Access reports have their own way of ordering and grouping. Doing it in the query won't work. You have to use the report builder's method to insert ORDER BY and GROUP BY. It is almost exactly like the Report Wizards read the SQL of your query and remove the ORDER BY and GROUP BY clauses entirely. No, don't ask me why it does that. I have no clue, but it is what it is.

The next question is whether you meant that there is some numeric element to the neighborhood but it is being returned alphabetically by the name of the neighborhood. OR did you mean that it was alphabetically with respect to another field?