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