home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a108 / 11.ddi / SALESDAT.QP_ / SALESDAT.bin
Encoding:
Text File  |  1994-03-10  |  855 b   |  25 lines
  1.  
  2. * WIZNAME = WZ_BQUER
  3. * VERSION = .72
  4. * TIMESTAMP = 476774400.0000
  5. * CLIENTSERVER =
  6. * TABLES = C:\FPW26\SAMPLE\CATALOG\INVOICES.DBF
  7. * FIELDS = Invoices.idate;TOTALSALES=SUM(Invoices.itotal);ORDERS=COUNT(invoices.ino)
  8. * SORT FIELDS = Invoices.idate
  9. * SORT ORDER = DESCENDING
  10. * GROUP = Invoices.idate:1D
  11. * SQL = SQL Select statement for Mailmerge Wizard:
  12. *SELECT Invoices.idate,SUM(Invoices.itotal) TOTALSALES,COUNT(invoices.ino) ORDERS ;
  13. *    FROM ;
  14. *         C:\FPW26\SAMPLE\CATALOG\INVOICES.DBF;
  15. *    ORDER BY Invoices.idate DESC;
  16. *    GROUP BY Invoices.idate;
  17. *    INTO CURSOR Query
  18. SELECT Invoices.idate,;
  19.         SUM(Invoices.itotal) AS TOTALSALES,;
  20.         COUNT(invoices.ino) AS ORDERS ;
  21.     FROM ;
  22.          LOCFILE("C:\FPW26\SAMPLE\CATALOG\INVOICES.DBF","DBF","Where is Invoices.DBF ?");
  23.     ORDER BY Invoices.idate DESC;
  24.     GROUP BY Invoices.idate;
  25.     INTO CURSOR Query