By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,556 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Count not working in report's page header

P: n/a
In my report I have a calculated field that counts the number of records of
the underlying table, =Count([ID_customer]). This field is placed in the
report's header. I'd like to repeat this value on every page but when I drag
the field to the page header it shows 'error' when I run the report. Can
someone explain why this isn't working? Any workarounds?
Thank you.
John
Dec 15 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I have no idea why it throws an error in the page header, when it
doesn't in either the report header or the detail section. Hopefully,
someone will be along shortly to tell you

However, you could put a text field in the page header referencing the
field in the report header eg ={Reports]![ReportName]![FieldName].
This does work
Dec 15 '07 #2

P: n/a
anthony wrote:
I have no idea why it throws an error in the page header, when it
doesn't in either the report header or the detail section. Hopefully,
someone will be along shortly to tell you

However, you could put a text field in the page header referencing the
field in the report header eg ={Reports]![ReportName]![FieldName].
This does work
Aggregate functions do not work in page header footers. Only in report header
footers and group header footers. You might be able to use...

=[NameOfTextBoxInTheReportHeader]

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Dec 15 '07 #3

P: n/a
Thanks Rick, Anthony.
John

"Rick Brandt" <ri*********@hotmail.comschreef in bericht
news:OP*****************@newssvr19.news.prodigy.ne t...
anthony wrote:
>I have no idea why it throws an error in the page header, when it
doesn't in either the report header or the detail section. Hopefully,
someone will be along shortly to tell you

However, you could put a text field in the page header referencing the
field in the report header eg ={Reports]![ReportName]![FieldName].
This does work

Aggregate functions do not work in page header footers. Only in report
header footers and group header footers. You might be able to use...

=[NameOfTextBoxInTheReportHeader]

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Dec 15 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.