On Tue, 10 Dec 2002, Peter Dow wrote:

>     SELECT CUSTNBR, CUSTNAME, SUM(INVTOT), CUSTYTD
>       FROM CUSTOMERFILE JOIN INVOICEFILE ON CUSTNBR = INVCUSTNBR
>      WHERE INVMONTH = 12
>      GROUP BY CUSTNBR, CUSTNAME, CUSTYTD
>
> I'm assuming that CUSTYTD is a field in your CUSTOMERFILE.

Excellent!  Good assumption, the YTD totals are in the customer file.
Here is what I used:

select cmcst#6, cmcst#3, cmcsname, sum(ihinvtot), cmytdsal
from custmp, invchp where
cmcst#6=ihcst#6 and cmcst#3=ihcst#3 and ihinvdate>'2002-11-30'
group by cmcst#6, cmcst#3, cmcsname, cmytdsal

Now I wonder how I can pass a date to this from say a CL program?  And
make it print instead of display?  I want to put this on a menu that
prints out the results for the current month.

James Rich



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.