Same query sorted on the ID showing correct Order on a Form and a Report but reversed order in a 2nd Report.

Hi all,

Same query sorted on the ID showing correct Order on a Form and a Report but reversed order in a 2nd Report.

I have a query having a sort order on the ID giving correct data when Viewed.
It is the source for a Form and Two Reports using the same results.
The Form and The First Report are showing the right data.
The 2nd report is also showing the same data but in Reversed Order!!!.
I checked and checked The SQL and design and I don't see any difference.

Help Please
Issa S.Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Bill PrewIT / Software Engineering ConsultantCommented:
In the second form, could you have an "Order By" property set for the Data source of the report?


»bp
Issa S.Author Commented:
Order By is blank,
Order by on Load is Yes.
Filter is bland,   and
Allow filter in No.
Pawan KumarDatabase ExpertCommented:
Try setting the order by.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Bill PrewIT / Software Engineering ConsultantCommented:
And the Query specifies a sort on the column you want, in ascending order?


»bp
Issa S.Author Commented:
Dear Pawan :

It does not give any option to change the Order By, remember I am talking about the 2nd Report.

To get things worst,  I matched the properties of the 2 reports and they are the same

Deaaar Bill,
Of course on the same field. The ID in both cases.
Bill PrewIT / Software Engineering ConsultantCommented:
Any chance you can upload the Access file that has this problem?


»bp
PatHartmanCommented:
Sort order for a report is not defined in the query.  It is defined in the report.  Look at the sorting and grouping options for the report.
Gustav BrockCIOCommented:
In fact, you should remove any sorting in the query and only specify ordering in the report itself.

/gustav
Issa S.Author Commented:
Tell Me How Pls.  My  mind is stuck now.

Report Properties now are:

Order By is blank,
Order by on Load is Yes.
Filter is bland,   and
Allow filter in No.
Issa S.Author Commented:
I also Tried : Removing the sorting from the Query and still the same   !!!!!!!!
Gustav BrockCIOCommented:
In report design, go to grouping and sorting and define the ordering you wish.

/gustav

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
Issa S.Author Commented:
Sorry Bill for being away for a while but I agree on your suggestion to close the issue.
Thanks to ALL who contributed in this.
Issa S.Author Commented:
Thanks a lot.
Worked nicely.
Gustav BrockCIOCommented:
You are welcome!

/gustav
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.