Avatar of Issa S.
Issa S.
 asked on

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
Microsoft AccessMicrosoft SQL Server

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon
Bill Prew

In the second form, could you have an "Order By" property set for the Data source of the report?


»bp
Issa S.

ASKER
Order By is blank,
Order by on Load is Yes.
Filter is bland,   and
Allow filter in No.
Pawan Kumar

Try setting the order by.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Bill Prew

And the Query specifies a sort on the column you want, in ascending order?


»bp
Issa S.

ASKER
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 Prew

Any chance you can upload the Access file that has this problem?


»bp
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
PatHartman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Gustav Brock

In fact, you should remove any sorting in the query and only specify ordering in the report itself.

/gustav
Issa S.

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

ASKER
I also Tried : Removing the sorting from the Query and still the same   !!!!!!!!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Issa S.

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

ASKER
Thanks a lot.
Worked nicely.
Gustav Brock

You are welcome!

/gustav
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.