Format label on a grouped Yes/No section 1

[scottian]

Is it possible to change the label text in the footer or header to reflect a grouped yes/no section?
Where the section shows a count of 'Yes'id like the label to read 'Total number of completed jobs' and where the section shows a count of incomplete jobs the label should read 'Total of incomplete jobs'.



"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks

 

[Hakala]

Hi, scottian!

I'm trying to visualize what you're asking but I'm having trouble doing that. Where would the "totals" come from? A Yes/No grouping is just a yes and a no checkbox (or radio button or toggle); there are no totals.

Help me help you?


Michelle Hakala

http://www.winebird.com/

 

[TheAceMan1]

How are ya scottian . . .

Be more specific in explaining whats in the group header. Not sure [blue]what to trigger on here! . . .[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[dhookom]

If I understand correctly, you could use a text box with a control source like:
=IIf([NoNameGivenForYN]=True,"Total number of completed jobs","Total of incomplete jobs")

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]

 

[scottian]

dhookom,
Thank you, how simple is that. Brilliant

"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks