Report Total Only Prints On Page # 1.

[skiphooper]

Hi Everyone,

I have a strange problem with my report.

I am using a Dcount statement in a textbox in the
Report footer section, to give me a total for the number
of records printed on the report.

This works fine when the report is limited to only 1 page.

As soon as the report spans more than 1 page I get
#Name? error.

Without changing any data for the report, if I increase the
size of the detail section I get the same error when report
exceeds 1 page. If the report is contained to 1 page
everything is OK.

What am I missing that could cause this.

Thanks in Advance

Skip
_______

 

[Rich]

Why use DCount ?

 

[skiphooper]

Hi Rich,


Only because I don't know what to use in it's place.

Even so, what would cause it not to print on pages higher

than 1.


Thanks

Skip
______

 

[skiphooper]

Hi Everyone,

Anyone have any idea's about this one.

Thanks

Skip
______

 

[Rich]

Try =Count(*)

 

[RichMorrison]

A brief review.

There are 2 forms of many built-in functions; the plain form and the "D" form. The "D" form is called a "domain" function.

The difference is that in the D form you specify a domain:
DCount("field","domain"[,"optional condition"])
Domain can be a table, or a stored query, or a SQL expression.

In a report you can use Count if you refer to a variable that is part of the RecordSource of the report;
=Count([SomeField])
or
=Sum([SomeField])

Rich's example, =Count(*), will give you a total count of all the records in the RecordSource of the report.

That works in a section Footer or in the one report Footer.

RichM

 

[skiphooper]

HI

Thank You Both

Skip
_________