Results 1 to 2 of 2

Thread: Report count

  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Manchester, Gtr Manchester, England
    Thanked 0 Times in 0 Posts
    Hi, Hans has shown me a way to count the unique occurence of an ID where it's displayed many times in a query and hence a report. The solution was to create a text box, set the source to =1 then to set as a running sum. This solved my problem becuase i needed a count of the individual occurence, however my problem has escalated a little since in that I need the count at a group level. So say I have an adviser who can have three types of sale A, B and C , my report is grouped by adviser, then sale type with the respective sale in its type. The total sales is in the footer and where the unique Id counting explained by Hans comes into it's own. However on the second agent name, his total footer shows a running overall total, i.e. his sales and that of the previous agent. Is there a solution to this?

    Thanks, Darren.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts
    Try setting the Running Sum property of the text box to Over Groups instead of Over All.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts