Re: Can I do this in Query

["Booth Martin" <Booth@xxxxxxxxxxxx>]

--
--
[ Picked text/plain from multipart/alternative ]
Can a query sort and do level breaks on a result field?  If so, can you
create a result field that puts in a 1, 2 , or 3, depending upon which
section?  ('X__' = 3,  'DSL' = 2, all others = 1)



---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@MartinVT.com
---------------------------------------------------------

-------Original Message-------

From: midrange-l@midrange.com
Date: Wednesday, November 20, 2002 10:08:22 AM
To: midrange-l@midrange.com
Subject: Can I do this in Query

Need 3 separate sections (i.e. level break) in a single Query report as
follows

Section 1: All items that do not have an X in pos 1 and do not have DSL
in pos 1-3

Section 2: All items that have DSL in item # pos 1-3

Section 3: All items that have X in item # pos 1

I know I could make it 3 separate queries with appropriate selection,
output to a file, then print vs that file but if at all possible would
like to do in 1 query…..

I can't figure a way to make it work….maybe it can't


Mark Allen
I.S. Manager
Wilkes Telephone & Electric
A Dycom Company
Phone: (706) 678-9565
Email: allenmark@nu-z.net
http://www.nu-z.net




_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

.
--
[ IMSTP.gif of type image/gif deleted ]
--