Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Manchester, Gtr Manchester, England
    Thanked 0 Times in 0 Posts

    Count in Reports (2000)

    Hello I am trying to get a count to work on a report: I have a regional manager who is selected from a drop down, a report is then run for that regional manager. Under each regional manager there are a number of area offices. I need my report to list the number of sales leads for each area e.g.
    if I select regional manager 'Jon Smith' then a report would run to show leads as North 2, South 3, East 7. All the AOs are listed in the detail area of the report. Currently I am using count [(sales)] which lists the overall sales for the regional manager when I require them to be broken down by each area office under a given regional manager.

    Regards Darren

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Count in Reports (2000)

    If you group the report by Area Office, you can put a text box with control source =Count([Sales]) in the group footer section; this will display the count of records for each Area Office.

    If you don't want to group the report, there are several alternatives, for example:
    <UL><LI>Create a totals query that counts the number of sales per area office for the regional manager selected in the combo box (using criteria of the form Forms!frmSomething!cboRegionalManager). Create a report based on this query, and place this as a subreport in the report footer section of the main report.
    <LI>If the number of regional offices is not too large, you can put text boxes in the report footer for each of them, with an expression using DCount in the control source:

    =DCount("*", "tblSomething", "[Regional Office] = 'North' And [Regional Manager]=" & [Regional Manager])[/list]Substitute the appropriate names.

Posting Permissions

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