Re: Help!! Totalling Results from "Count" function
- From: "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx>
- Date: Mon, 19 Sep 2005 16:10:44 -0500
First, create a totals query that is similar to your main report's query. I
expect you would group by department. This query should display the results
you want in your report footer.
Then create a report (subreport) based on your query. You can then add this
"totals" report as a subreport in your main report.
--
Duane Hookom
MS Access MVP
--
"dannablum" <dannablum@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F2D0E651-CD5D-4614-970C-A7A18A6DBF92@xxxxxxxxxxxxxxxx
> Duane:
>
> How, exactly, do I do this? I'm very new at Access. Could you be a bit
> more specific about what I should put where?
>
> Thanks so much.
>
> "Duane Hookom" wrote:
>
>> 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?
>>
>>
>>
.
- References:
- Re: Help!! Totalling Results from "Count" function
- From: Duane Hookom
- Re: Help!! Totalling Results from "Count" function
- Prev by Date: Re: Not all info is printing in subreport.
- Next by Date: Re: Question re: Doug Steele's DB Object Documenter report
- Previous by thread: Re: Help!! Totalling Results from "Count" function
- Next by thread: Sum Total in Text box of Report gives #Error
- Index(es):
Relevant Pages
|
