Crosstab report with totals in the footer

E

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
 
D

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.
 
E

elena

Thank you, Duane
TextBox in the Report Footer works.

Duane Hookom said:
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


elena said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top