re: A query question

[Glenn Gundermann <ggundermann@xxxxxxx>]

I have many queries that do this very thing.  It's not neat to say the least.

I wrote multiple queries and do multiple passes as follows;

- the first query does a select on fieldx='00' and calculates result fields
debit_amount=amount_field, credit_amount=0.  Output is to a file with all
the necessary fields plus the two new ones.

- a second query does a select on fieldx<>'00" and calculates result fields
debit_amount=0, credit_amount=amount_field.  Output is to the same file,
adding to the member.

- the last query will report from the output file.

I unfortunately have had to produce a report that took 14 queries in total.
Nice looking report and if you saw our database you would never think it was
possible.

Hope this helps.  Glenn

At 07:46 PM 6/5/97, boothm@earth.goddard.edu wrote:
>Here's the issue:
>We have two files.  
>One is the Name master file.
>The other is the Detail file.
>A field in the Detail file has both debits (as a +) and credits (as a -),
>Also the Detail record has a field that can be 00 (00 is always a debit),
>or the field can be any number 01 thru 99 (and never a debit).
>
>I'm sure you can already see the question:  How do we write a query
>showing the customer's name. his total debits, and also his total credits. 
>We know the difference is usually near 0.00, but we'd like to know the
>business volume he's done.
>
>Can this be done with Query/400?  
>We've got a $.25 bet riding on this...
>-- 
>-----------------------------------------------------------
>boothm@earth.goddard.edu
>-----------------------------------------------------------

    _/_/_/_/   _/         _/_/_/_/   _/_/    _/   _/_/    _/
   _/         _/         _/         _/ _/   _/   _/ _/   _/
  _/  _/_/   _/         _/_/_/     _/  _/  _/   _/  _/  _/
 _/    _/   _/         _/         _/   _/ _/   _/   _/ _/
_/_/_/_/   _/_/_/_/   _/_/_/_/   _/    _/_/   _/    _/_/

Glenn Gundermann
ggundermann@ibm.net
work tel: (416) 967-8222
cel:      (416) 409-4551

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *