OPEN DATABASE "db";

FIELD name = name1 & " " & name2;

REPORT 
   SELECT
      custno "Custno.", matchcode "Matchcode",
      name "Company", turnover__1 "Monthly Sales"
   FROM customers
   WHERE turnover__1 > 0
   ORDER BY 1
TITLE AS "CUSTOMER SALES FOR CURRENT MONTH/SORTED BY CUSTOMER NUMBER/"
DATE AS TODAY;
