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