Qdesign - Sorting Question

[Terry Curran]

This is a multi-part message in MIME format.

------=_NextPart_000_0008_01C2805B.7D6426D0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

If you are using a database you can simply add the order by statement to
your file access statment

access file-a via item-a using item-a request item-a order by item-b

Of course this is a PowerHouse 8 feature, and requires a relational database
to work, if you had providewd some more info in your email then it would
have been more helpful

>  -----Original Message-----
> From: 	powerh-l-admin@cube.swau.edu
> [mailto:powerh-l-admin@cube.swau.edu] 
> Sent:	30 October 2002 18:42
> 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.
> 

------=_NextPart_000_0008_01C2805B.7D6426D0
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="winmail.dat"

eJ8+IjcVAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANIHCgAeABUAHQAAAAMANgEB
A5AGACwNAAApAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAEAAAADAC4AAAAAAAIBMQAB
AAAA/gAAAFBDREZFQjA5AAEAAgB6AAAAAAAAADihuxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwA
AAAAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcRG9jdW1lbnRzIGFuZCBTZXR0aW5nc1xUZXJyeVxN
eSBEb2N1bWVudHNcT3V0bG9va1xvdXRsb29rLnBzdAAYAAAAAAAAAFnGd3ZO4LdLrwuinMrwFaqi
gAAAAAAAABgAAAAAAAAAWcZ3dk7gt0uvC6KcyvAVqsKAAAAQAAAAcowEJ0YWsU2ugs2lL6LxKx8A
AABSRTogUWRlc2lnbiAtIFNvcnRpbmcgUXVlc3Rpb24AAAADADYAAAAAAB4AcAABAAAAGwAAAFFk
ZXNpZ24gLSBTb3J0aW5nIFF1ZXN0aW9uAAACAXEAAQAAABsAAAABwoBEARFCQKVGvSxAJaM5xCfe
U93KAAW9iQAAAgEdDAEAAAAfAAAAU01UUDpURVJSWUNVUlJBTkBPTkVURUwuTkVULlVLAAALAAEO
AAAAAEAABg4AdmBcW4DCAQIBCg4BAAAAGAAAAAAAAABZxnd2TuC3S68LopzK8BWqwoAAAAsAHw4B
AAAAAgEJEAEAAABkBwAAYAcAAPoLAABMWkZ1t22EBAMACgByY3BnMTI1FjIA+Atgbg4QMDMzTwH3
AqQD4wIAY2gKwHPwZXQwIAcTAoMAUBBv0EVudmkDYEQCgw5QMRI2cHJxFAEQ51RhNmgDcQKDMwLj
EMcyIFJXC4BnZBdhcwKDNG8DRRapBrQCgzUSLxWHfbMKgAjIIDsJbw4wNRyvemUOIDgd8x8RHl4b
wVwrE2AH0GsLgGQYMHVjGwBQCwNjEgILxCBJZhQgeQhgIArAZSB1RwCQDyAjUCBkYQGRYVsRICMT
YwORAJBtC1B5wSNQZGQgdGgjgAWwKQSBIGIlgHMBkHRltweAAjAl0G8jEgXAZgMQ+yOAANBjB5AE
ICayJwIKou8KhAqAKCUn0i0kABNgJAC+aSbhKoEjpCr1CXBxClC/JrAq5iYnKvMMMCkpTyMA/wWg
CHAkgSXgBAAq4AQgJABoUG93BJBICGAkgTjNJ8BlJDAIcGUsI1AhYJ8sIxNwB5EsEgtgdGkCINcH
QCQYJ1F3BbBrMVAGkG8jExDwJcAUoG8TYAEAd/0lwHMDcCOABGAjcQuAAhD/NhEndCbwC3ADICXh
A6Aq8FkzwXVsJcAQ8HYjgGLHCeE1xCXwbHBmN/ApGuEK9GxpMzYBQCIwAUAbNOEm4GMpABIDMjQg
DwMwDwQ8IBPkMTYgLbU9gk8FEGcLgDLhTShR/GFnKnA9gikWO2Q7MQsTwTtmaS0xNDQBQDqwODE4
MAFADNBBI2IgWkYDYToDMAySYhFQcJEwImgtbCqAZG0LgChAY3U4gC4D4GF1ti4JgCNAWzcCJ1A6
Q199RGldCuMKgUJQBmACMDrVQtYzEVBPO6BvOIAFwMsB0DzAIEGQOjQOUEeWvlRFgELWMBMVsDCC
TAQAtwVABmE4UHJHiERQajuRrUhXUQEAAJBnA6AtBgD7CREjwlEsYjKxOZw/rzuS/m4wIDUgO6A5
QArAOqUPBvU7x0kjUG0sICQwJfAFwH8msU6wAHAskTixJYAwgm+5IwBRRE6GVGAjoHUHQO8lcQEA
OFAJAHAlJCOABPHvCeEEIAPwJeAgOrACQCfx/zXTJeADkQlxARALgAeRVlHvJCIxY1tjRaBwN/Ay
kyZw/yRxJcBcwTCBBcAyAUWgAID9B5AuPEAwYDAwTKExUC9z/zKgNaFUYDgzK0ImUVpBN7F/VXEv
0li0YJQvkQlwV3Nt+yGgWWJrYBIJcEWgACBeYfpUL4VqI6AFQCQAWtE1Yf9hiTqwJrBZERWwL7Jc
wVdQ913wWPFcsihXRifwBBFaQ9NhVzlhbClkAmUlgDfU/2MjL3Ro4TlAEPAmGAtgLIH/MtA1oTFy
bMMvkVIwZNJjQDclgCfQMnBkXmEpGkFu9yWACXAFoG0nASQhMrFm0/cVsAfgJ1FzcSMl8VtjNYD/
ACBdISXiRKAlgCXhaEFjMv9n11RgZKMm4FeAJdJUkHNj71rwXSEkADHRemOFNhEmsP8w8F0xIwBh
VmnQWTIIYAVA3xDhDyAjwiXiJrByIaAxEndWQnHmJGI/KRpkIABwa/UjEiwpFENUw1rhUG9Rf/1S
i3EA4DmqIjAUARZBC/L9KSN2gq+DaYEnFkELwkGQPiB9J0wRAkAJ8DFQU3I9XmBQA2AJwFSAB4By
L9tvsAdAeSawMVBWV3FqIf+HAAeQJoAm4AchA6AwYF3wryrwMuEpFEnQNQ9AN4gxe3+BN3FTedAJ
4IgTA6BOhnWH8DFQQ0EgOUEgJDA1PEAoOEGQKTewODIuNjrgEVB4SYDfjMFHdiIxJOF9RS5Zggnw
vEB2iFMUoF5BBbBngS//EVAEEJJfkzsYEikkAKAaA8+FcWoBJdEIYGdoYSAxUD9wFJYiMXJYEAuA
cKNlePeQkl0SVOFla1IjcUZRRHD9aeVkJ2Bt0glwDvA7kZWyz1YkVeEm8AtQb3le4n+AvwXAAHAj
IIYRMnARIC6Udv8C0ZHfnu+T9H3PQEk6tIjg+w9AomFhoqKAoYToPWBkI/xFLTcDL5EFoEyhXSEm
gd0l4kWaggNgAwBjhZBwIa51poFwhYcAaZAwYyWADkE7oDFQhXFVLlMuwkNeYFwnYTepIkmAfYqR
LQ4xjwAxci+RJ/Bn/1dzFKCn0CfhPrBusWQkNjH+cgDAXKOk8zYwNSECMAcx/6xLqlULgIZxAQBd
MiVxrHH/JdNWFSXiIVGrYUTwMuEFsf2tonR10WzRdiEG4DhQXmD/IvEl4mJhJkJ6Yy+RB4E+kv9t
lrEUr2Vv8QUgCJACMDFQ/yMmmHImgW3RBpAIkCXCYMH/nHEkEAQBJvA+ETKiMVC5UXl50GlieMBc
sgWxBaBw/nkjwrRWcBKnBy+yumJSgfWrIm8vgGIq8W6yIvU4M/9v8ZigOFAlwl9CVLAAgEZQ/wQQ
rNMDoASQA2Be8VhxJHL/uDOltBEgr4EFwAdwssEHMP91ASWAJoEJcDERwTGmKMBbfzFyN1TDaQEA
J/Am4L//bn+dJqDPodk7EjvVKRQbwQABzJAeAEIQAQAAAD8AAAA8TURFRExORUVFRUJDR0tLQktD
QUtHRUNJS01BRC5jYXRoZXJpbmUubGl0dGVuQHZhbGxleXByZXMub3JnPgAAAwABbiAAAAALAAGA
CCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAA4AIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAA
AAAAAwAHgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAACdqAQAeAAmACCAGAAAAAADAAAAAAAAARgAA
AABUhQAAAQAAAAQAAAA5LjAAHgAKgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAA
AB4AC4AIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAAyACCAGAAAAAADAAAAA
AAAARgAAAAA4hQAAAQAAAAEAAAAAAAAACwANgAggBgAAAAAAwAAAAAAAAEYAAAAAgoUAAAEAAAAL
ADqACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAPIAIIAYAAAAAAMAAAAAAAABGAAAAABGF
AAAAAAAAAwA9gAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAALAGyACCAGAAAAAADAAAAAAAAA
RgAAAAAGhQAAAAAAAAMAbYAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAAAgH4DwEAAAAQAAAA
WcZ3dk7gt0uvC6KcyvAVqgIB+g8BAAAAEAAAAFnGd3ZO4LdLrwuinMrwFaoCAfsPAQAAAHoAAAAA
AAAAOKG7EAXlEBqhuwgAKypWwgAAUFNUUFJYLkRMTAAAAAAAAAAATklUQfm/uAEAqgA32W4AAABD
OlxEb2N1bWVudHMgYW5kIFNldHRpbmdzXFRlcnJ5XE15IERvY3VtZW50c1xPdXRsb29rXG91dGxv
b2sucHN0AAAAAwD+DwUAAAADAA00/TcAAAIBfwABAAAAOQAAADxMSEVMS1BBTFBMRktMTklHRkxF
S09FT0NDRkFBLnRlcnJ5Y3VycmFuQG9uZXRlbC5uZXQudWs+AAAAAAMABhBAC2TwAwAHEPQGAAAD
ABAQAAAAAAMAERACAAAAHgAIEAEAAABlAAAASUZZT1VBUkVVU0lOR0FEQVRBQkFTRVlPVUNBTlNJ
TVBMWUFERFRIRU9SREVSQllTVEFURU1FTlRUT1lPVVJGSUxFQUNDRVNTU1RBVE1FTlRBQ0NFU1NG
SUxFLUFWSUFJVEVNLQAAAABy0g==

------=_NextPart_000_0008_01C2805B.7D6426D0--