Re: Can I do this in Query

[Dan <dbcemid@xxxxxxxxx>]

Well, I can think of a way to knock it down to 2 queries.

One query could do sections 2 & 3.  Select only those records that have
DSL and X, sort & break on that.

Otherwise, maybe a preprocessor of a kind, if you can somehow
substitute a given value for each of your 3 selections.  Doesn't
OPNQRYF have some magic tricks to substitute a value when a given field
doesn't equal 'DSL' or 'X'?

Maybe SQL?

- Dan

--- Mark Allen <allenmark@nu-z.net> wrote:
> 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…..

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com