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
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
ASKER
Order By is blank,
Order by on Load is Yes.
Filter is bland, and
Allow filter in No.
Order by on Load is Yes.
Filter is bland, and
Allow filter in No.
Try setting the order by.
And the Query specifies a sort on the column you want, in ascending order?
»bp
»bp
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.
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.
Any chance you can upload the Access file that has this problem?
»bp
»bp
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In fact, you should remove any sorting in the query and only specify ordering in the report itself.
/gustav
/gustav
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.
Report Properties now are:
Order By is blank,
Order by on Load is Yes.
Filter is bland, and
Allow filter in No.
ASKER
I also Tried : Removing the sorting from the Query and still the same !!!!!!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Thanks to ALL who contributed in this.
ASKER
Thanks a lot.
Worked nicely.
Worked nicely.
You are welcome!
/gustav
/gustav
»bp