Re: Can I do this in Query

Mark,

I think others have suggested it (I threw away the posts, after quickly reading 
them),  but  I would think in the line of :

SELECT fields, 'A' AS Token
FROM  file
WHERE SUBSTR(fielda, 1, 1) <> 'X' AND SUBSTR(fielda, 1, 3) <> 'DSL'
UNION
SELECT fields, 'B' AS Token
FROM  file
WHERE SUBSTR(fielda, 1, 3) = 'DSL'
UNION
SELECT fields, 'C' AS Token
FROM  file
WHERE SUBSTR(fielda, 1, 1) = 'X'
ORDER BY Token, fields

With Query Manager you can create a FORM  with Token as the Break Level.

Just a thought.

Regards,
Carel Teijgeler.



*********** REPLY SEPARATOR  ***********

On 21-11-02 at 7:45 Evan Harris wrote:

>- create a file that has a one character field in it.
>- add a "D" and an "X" record
>- join the files (if possible) by substringing the first position
>- include unmatched items
>- break on the value in the joined to file (i.e. the single character
>field)

>>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