RE: Can I do this in Query

["Rubino, Jim" <Jim.Rubino@xxxxxxxx>]

I think this will work for you to get the records in one query report, but
not sure how you can
have it break on the each the scenarios you need.  You could just do the 2nd
and 3rd in one query and sort by the new field called FLD1 and break on
that.


In the query go to the Define Results Fields and SUBSTR out the 1 char and
the first 3 char into
new fields as show below (you need to replace the imlitm with you file field
name).

============================================================================
======================


                              Define Result Fields

 Type definitions using field names or constants and operators, press Enter.
   Operators:  +, -, *, /, SUBSTR, ||, DATE...

 Field       Expression                         Column Heading        Len
Dec
 FLD1        substr(imlitm,1,1)



 FLD3        substr(imlitm,1,3)



Bottom
============================================================================
======================

After you get the fields defined you need to go to the Select Records and
key the following to get
the records you need.

============================================================================
======================


                                 Select Records

 Type comparisons, press Enter.  Specify OR to start each new group.
   Tests:  EQ, NE, LE, GE, LT, GT, RANGE, LIST, LIKE, IS, ISNOT...

 AND/OR  Field             Test   Value (Field, Number, 'Characters', or
...)
         FLD1              NE     'X'
  AND    FLD3              NE     'DSL'
  OR     FLD3              EQ     'DSL'
  OR     FLD1              EQ     'X'



Bottom


============================================================================
======================

I hope this helps you.

Jim


-----Original Message-----
From: Mark Allen [mailto:allenmark@nu-z.net]
Sent: Wednesday, November 20, 2002 9:07 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.