Re: Can I do this in Query

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Carel, you beat me to it. But he is using Query/400, not Query Manager.

Can you suppress the Token column in the form - it'd be nice not to see it.

Regards

Vern

At 09:39 PM 11/20/2002 +0100, you wrote:
> 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