Hello all, I have a report that displays member counts by MONTH and by PRODUCT TYPE. There have always been 3 PRODUCT TYPES (RG1, RG2, RG3), until now. Each Product Type has several members counted in each, (i.e. RG1 = 20,000 member count, RG2 = 14,300 member count, etc.)
Administration has added 2 new PRODUCT TYPES (NG1, NG2). The problem is, they want to see separate subtotals; 1 subtotal for the existing 3 Product Types and a separate subtotal for the 2 new Product Types - ON THE SAME REPORT. The 2 new Product Types have been added to my tables and queries and are displaying in the report, however, I do not know how to produce a separate subtotal for the 3 original Product Types. For example; the report is Control Source [=SUM(Jan 08)] this subtotals ALL Jan 08 membership and does not report out by OLD and NEW Product Types. I thought that I could use the Expression Builder to qualify on the specific Product Types, but I am having no success. Can anyone please advise? Thanks, Mark
