Crosstab report with totals in the footer

[elena]

Hi, All
I have report (record source is crosstab query)
Thanks to Karl (detail line totals now in place)
TRANSFORM Nz(COUNT(TempTicks.TicketNo),0) AS CountOfTick
SELECT TempTicks.Shield, Nz(COUNT(TempTicks.TicketNo),0) AS Total
FROM TempTicks
GROUP BY TempTicks.Shield
PIVOT fWeekdayName(DatePart("w",TempTicks.IssueDate)) & " " &
TempTicks.IssueDate;
When i use textbox control in the Page Footer and assign Control source
property to
=Sum([Total]) it lets me save the change, but running report shows #Error

Result now:
Sheld Sunday 09/17/2007 Monday 09/11/2007 ....Total
999 35 45 80
111 60 15 75
?_______________________________________________
Total #Error ? #Error ? #Error ?

How can i assign Control source for the textboxes in the
Page Footer for the Totals? I am using the name of the
controls in detail line...
Please, advice

 

[Duane Hookom]

You can't normally create aggregates in the Page Footer section. Use the
Report or Group Footers.

I don't think assigning control sources is a good solution. I would use the
solution described at http://www.tek-tips.com/faqs.cfm?fid=5466. This is for
monthly intervals but could easily be changed to daily intervals.

 

[elena]

Thank you, Duane
TextBox in the Report Footer works.

You can't normally create aggregates in the Page Footer section. Use the
Report or Group Footers.

I don't think assigning control sources is a good solution. I would use the
solution described at http://www.tek-tips.com/faqs.cfm?fid=5466. This is for
monthly intervals but could easily be changed to daily intervals.

--
Duane Hookom
Microsoft Access MVP

Hi, All
I have report (record source is crosstab query)
Thanks to Karl (detail line totals now in place)
TRANSFORM Nz(COUNT(TempTicks.TicketNo),0) AS CountOfTick
SELECT TempTicks.Shield, Nz(COUNT(TempTicks.TicketNo),0) AS Total
FROM TempTicks
GROUP BY TempTicks.Shield
PIVOT fWeekdayName(DatePart("w",TempTicks.IssueDate)) & " " &
TempTicks.IssueDate;
When i use textbox control in the Page Footer and assign Control source
property to
=Sum([Total]) it lets me save the change, but running report shows #Error

Result now:
Sheld Sunday 09/17/2007 Monday 09/11/2007 ....Total
999 35 45 80
111 60 15 75
?_______________________________________________
Total #Error ? #Error ? #Error ?

How can i assign Control source for the textboxes in the
Page Footer for the Totals? I am using the name of the
controls in detail line...
Please, advice