John, That's PERFECT!!! Thank You!!!
I'm almost there with this issue. I finally got the right total count but
I
also need the daily count to work, too.
Currently, on the top grouping [CreatedDate] by Day, each line gives me
sums
of their respective data, except [Tickets] which still gives me total
entries.
Example:
------------------------------
Date Tickets Parts
3/2/09 116 116
3/3/09 41 41
3/4/09 61 61
3/5/09 50 50
3/6/09 82 82
Total 350 350
------------------------------
txtCountTickets = 204
As you can see, the totals in both columns are the same, where the first
column should add up to equal the txtCountTickets.
Thanks Guys!!!
TraciAnn
John Spencer said:
Try the following:
--add another grouping level based on Tickets and show the group header
--set the visible property of the group header to false (no)
--add a textbox control to the group header
-- Name: txtCountTickets
-- Value: =1
-- Running Sum: OverAll
-- In the report footer, add a textbox control and set its control
source to =[txtCountTickets]
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
Well, part of the summary is to count total tickets. It doesn't seem
like a
problem, but, the report is counting each instance of the [TicketID]
from the
RequestParts table. Therefore, I have the same number of Tickets as I
do part
requests.
I only want to count each ticket once rather than each time it has a
RequestedPart.
Can you help Clif?
Thanks!
TraciAnn