SELECT AgeRep.*,;
       (DAY3060+ DAY6190+ DAY91120+ DAY121150+ DAY151180+ DAY181240+ DAY241365+ DAYOVER365) AS nTotal,;
       NVL(PCode.PName,PADR("Missing PName from PCode",52," ")) AS PName;
       FROM AgeRep;
       LEFT JOIN PCode ON AgeRep.PCode == PCode.PCode;
       WHERE (DAY3060+ DAY6190+ DAY91120+ DAY121150+ DAY151180+ DAY181240+ DAY241365+ DAYOVER365) # 0;
       ORDER BY AgeRep.PCode, Reference, Date,  AgeRep.SalesMan;
       INTO CURSOR cAgeRepo
       
** You can print all rows including empty ines (that ALL DAY.. are zeros) If You remove
** WHERE (DAY3060+ DAY6190+ DAY91120+ DAY121150+ DAY151180+ DAY181240+ DAY241365+ DAYOVER365) # 0
** in SELECT../.

SELECT cAgeRepo
GO TOP
REPORT FORM AgeRep TO PRINTER PROMPT PREVIEW 
USE IN cAgeRepo