report form sort by ascending order

okay another question -- I have a report that I want in the following format

From   To   Description
  0        2   aserjasdjfkdxfa
  2       10  aktj;aslkmf'sadlv
 10      50  akjsr;elasjkfd;vlkz'c

In my query for the report I already put the From field in ascending order and when I look at the result the table IS in ascending order but in the report it's in descending order.  How do I force it to appear in ascending order in the report?


I still haven't solved my vertical line problem
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Check your sorting and grouping options in design view.  Query results may have been over-ridden by a wizard.
MeilaniZamoraAuthor Commented:
I don't have anything grouped and the only thing I have in any order is [DepthFrom]
Is from a text or number field?
Can you post the syntax of the query whicxh is the source of the report?
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

MeilaniZamoraAuthor Commented:
it is a number field

SELECT tbl_GeologyLogOverview.HoleID, tbl_GeologyLogOverview.DepthFrom, tbl_GeologyLogOverview.DepthTo, tbl_Header.EOH, [DepthTo]-[DepthFrom] AS Length, tbl_GeologyLogOverview.LithologyID, tbl_GeologyLogOverview.UnitCode, tbl_GeologyLogOverview.ModelCodeID, tbl_GeologyLogOverview.ModelCode, tbl_GeologyLogOverview.OlivineGrainSize, tbl_GeologyLogOverview.MagmaclastGrainSize, tbl_GeologyLogOverview.TexturalClassification, tbl_GeologyLogOverview.Description
FROM tbl_Header INNER JOIN tbl_GeologyLogOverview ON tbl_Header.HoleID = tbl_GeologyLogOverview.HoleID
WHERE (((tbl_GeologyLogOverview.HoleID)=[Forms]![frm_Master]![frm_Header].[Form]![TxtHoleID]))
ORDER BY tbl_GeologyLogOverview.DepthFrom;
The comment from jerryb30 is correct, to sort (even when you have no grouping) you need to place the fields in the Grouping popup form. (Press the [= looking button)
Select the field(s) and set the sort property of the row as you want.

MeilaniZamoraAuthor Commented:
sorry but where do I find the Grouping popup form  - What/Where is the [= button?

I'm SO confused
Then use the menu: View/Sorting and Grouping
The button's image is just in front of the choice :-)


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MeilaniZamoraAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.