Re: Help!! Totalling Results from "Count" function

Tech-Archive recommends: Fix windows errors by optimizing your registry



Use a totals query as the record source for a subreport that you place in
the report footer.

--
Duane Hookom
MS Access MVP
--

"dannablum" <dannablum@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6AE76E90-CC42-47CC-8696-904E7786EF26@xxxxxxxxxxxxxxxx
> In my report, I have used the count function, showing a count of employees
> within different departments, no problem. However, I need to show, in the
> report footer, the total of the results from those counts. How do I do
> this?


.



Relevant Pages

  • Re: SubReport-Only last record from detail shows
    ... The links provide a filter to the subreport. ... >> Duane Hookom ... >> MS Access MVP ... >>> when I place it in the report footer of the Master Report it only shows ...
    (microsoft.public.access.reports)
  • Re: How many?
    ... I liked John Spencer's answer better... ... >> Duane Hookom ... >> MS Access MVP ... >>> in this field and display this in the report footer. ...
    (microsoft.public.access.reports)
  • Re: How to have a report give me a TOTAL from a query
    ... > I am putting a unbound text box in the footer and in the ... >>Did you place this in a REPORT FOOTER section? ... >>Duane Hookom ... >>MS Access MVP ...
    (microsoft.public.access.reports)
  • Re: Column totals in Access
    ... >> Duane Hookom ... >> MS Access MVP ... >>> I can't get them to total in the report footer. ... The second column totals fine. ...
    (microsoft.public.access.reports)
  • Re: Summing Grouped Totals
    ... Is your text box in the Page Footer or Report Footer section? ... "Drew" wrote in message ... > "Duane Hookom" wrote in message ... >> MS Access MVP ...
    (microsoft.public.access.reports)