home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
ssql23.zip
/
RPT4.FRM
< prev
next >
Wrap
Text File
|
1990-11-11
|
658b
|
26 lines
--RPT4.FRM (Be patient when running this one. It actually
-- contains three queries)
--
HT SALES REPORT
HT MONOLITH MANUFACTURING
HTCustomer Name Product QTY
HT--------------- ---------- ---
DTXXXXXXXXXXXXXXX XXXXXXXXXX 999
1T ------
1T The customer total is 99,999
1T
GT -------
GT GRAND TOTAL ............999,999
ET
ET^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
ET END OF REPORT
ET^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
DC name, descrip, qty
1B name
1C sum(qty)
GC sum(qty)
TA sales,prod,cust
WH sales.cc = cust.code and
WH sales.pc = prod.code