June 11, 200520 yr I have a feeling an obvious answer is lurking on the fringes on my mind but I can't quite get it out in the open. I have a report based on a table CallCodeOccurence I have it subsummarizing by CallCodeType (from the related table CallCode) The rows are basically a date, a call code, a description and a count field. No problem counting the CallCodeOccurence records or totalling them. But at the end of this report I need include a total number of CallCodeTypes that appear in the report (it's filtered by date range and other things). So how can I display a total count of the CallCodeTypes? I tried a summary field that counts CallCodeTypes but I get a value of 1 regardless of where I put it, even in a trailing grand summary. So I'm missing a concept or two here I think.
Create an account or sign in to comment