RE: query question

Doug,

I think what you want to do is this:

1. Select Sort Fields (customer#, Date)
2. Define Report Breaks (1 on company, 2 on date)

Your output will not repeat data that is defined Define Report Breaks.  You
can also add Report Summary Functions to create subtotals, counts, etc.

I hope this is what you're looking for.

Phil

> -----Original Message-----
> From: midrange-l-admin@midrange.com
> [mailto:midrange-l-admin@midrange.com]On Behalf Of Doug Johnson
> Sent: Friday, October 19, 2001 2:40 PM
> To: 'midrange-l@midrange.com'
> Subject: query question
>
>
> Greetings,
>
> I am trying to write a query that will pull data from several files.  They
> do have a common field that I will use for the selection, but joining the
> files on that field of course results in extraneous records in
> the output. I
> need some way to merge the data selected instead and then sort it by
> customer and date.
>
> This is what we are looking for as output for example:
>
> charge account activity sorted by account # and date
>
> Customer number       Date1   Item1   Purchase amount
>                       Date1   Item2   Purchase amount
>                       Date2   Item1   Purchase Amount
>                       Date3   Payment amount
>                       Date4   Item1   Purchase amount
>                       Date5   Payment Amount
>
>
> Purchases and payment history are separate files with different fields and
> formats.
>
> Am I missing the obvious here or is it not possible to do this with query?
>
> Thanks,
>
> -doug
>
>
> ************************************************
> DOUGLAS JOHNSON
> System Administrator
> The University Book Store
> 711 State Street
> Madison, WI 53703
>
> djohnson@univbkstr.com
> 608-257-3784
> 608-257-9479(fax)
>
> _______________________________________________
> 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.
>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com