Here
Results 1 to 3 of 3
-
Silver Lounger
- Join Date
- Jun 2001
- Location
- Niagara Falls, New York, USA
- Posts
- 1,843
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-07-19 11:26Sort Not Working? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2004-07-19 11:31Re: Sort Not Working? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Reports ignore the sort order of the record source. You MUST open the report in design view, specify the desired sort order in the Sorting and Grouping windows, then save the report design. Does that fix your problem?
(If the report displays the records in the desired order without having specified it in the Sorting and Grouping window, it is by accident, you can't rely on it, as you have found.)
-
Silver Lounger
- Join Date
- Jun 2001
- Location
- Niagara Falls, New York, USA
- Posts
- 1,843
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-07-19 15:11Re: Sort Not Working? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
I knew that!
The following in Report_Open quickly sovled the problem
Me.RecordSource = gloGetValue("ReportRecordSource")
Me.OrderBy = gloGetValue("OrderBy")
Me.OrderByOn = True
Thanks, John
PS: Your not going to believe what I have been getting away with for over two years.
The way this was working for me in the past was to build a tblResultsBP file of the autonumber
