Control Source in Text Box 2

[RangerFan]

What I would like to do is display a final report total in a text box, but not one that would simply use the SUM, or COUNT functions.

I have a series of line items in a report, and on each detail line is a CHECK BOX. I would like a total at the end of the report that reflected a count of only those check boxes that were in fact checked, or have a value of TRUE.

Is this possible using the control source of a text box?

Any help would be appreciated.

 

[mhartman1]

Hello

Yes, you could use the Dsum or Dcount function to specify which records to count or sum. Many examples are in the help section.

Regards
Mark

 

[RangerFan]

Thank you Mark. I will check those out.

 

[RangerFan]

Mark,

That worked just fine. Thank you.

 

[mhartman1]

Your welcome!

 

[dhookom]

To count the True values, use an expression in a report footer like:
=Sum(Abs([YourYesNoField]))
Using any domain aggregate function like DCount() or DSum() could create errors if the report is opened with a Where Condition.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]