Qdesign - Sorting Question

[Johnson, Harold A EDUC:EX]

Here's a couple of ideas:

1.  use the ORDERBY clause of the ACCESS statement for a FILE.

2.  produce the list in a report file and display using your local editor
(read only mode).

cheers!

>  -----Original Message-----
> From: 	Catherine Litten [mailto:catherine.litten@valleypres.org] 
> Sent:	Wednesday, October 30, 2002 10:42 AM
> To:	Powerhouse List Server
> Subject:	Qdesign - Sorting Question
> 
> I am rather stagnant in my use of QDesign - I usually develop simple
> screens with little more than redefines of data and data population based
> on user responses.  However, this time I have a user that wants a screen
> that is really much like a report.  This is just a find screen that lists
> who is on suspension (usually less than a screen full)  They would like
> this in alpha order by last name and name is not a key field.  
> 
> Any recommendations on how to show the data sorted the way they like
> (usually I just tell them they need a quiz report instead of a screen)
> without changing the structure of the database?
> 
> Thank you,
> Catherine
> 
> 
> 
> *****************************
> Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian Hospital 
>  15107 Vanowen Street, Van Nuys, CA 91405  (818)782.6600 x 2140 
> catherine.litten@valleypres.org
> ********************************
> The thoughts, comments, and opinions expressed herein are mine.  They do
> not reflect those of my employer, nor anyone else.
> ********************************
> This E-mail is covered by the Electronic Communications Privacy Act, 18
> U.S.C. §§ 2510-2521 and is legally privileged. This information is
> confidential information and is intended only for the use of the
> individual or entity named above. If the reader of this message is not the
> intended recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited.  If
> you have received this transmission in error, please notify the sender
> immediately by return electronic transmission and then immediately delete
> this transmission.
>