Command Button to make Format Vision "Yes" and "No"

[Frank Situmorang]

Hello,

At the Report Footer I have a kind of statistics of membership query using
Total as follows:

TotalAll: Sum(IIf([JenisKel] Is Not Null,1,0))
TTLMale: Sum(IIf([JenisKel]="L",1,0))
TTLFemale: Sum(IIf([JenisKel]="P",1,0))
ActiveMale: Sum(IIf([STAT_CODE]="A" And [JenisKel]="L",1,0))
ActiveFemale: Sum(IIf([STAT_CODE]="A" And [JenisKel]="P",1,0))
PassiveMale: Sum(IIf([STAT_CODE]="I" And [JenisKel]="L",1,0))
PassiveFemale: Sum(IIf([STAT_CODE]="I" And [JenisKel]="P",1,0))

Is there any way to make a command button in this report footer to have:

Page header and Detail format Vision to Yes and then back to No>??

I appreciate for anyidea provided

 

[Evi]

You can't put controls that do things into reports, only into forms.
Evi

 

[Frank Situmorang]

Thanks Evi, I will make it in form because the Sumif can also be used in the
formfooter I think. My main purpose is for the Pastor to see at glance on
the statistik and then he clicks the button and he can see who is inactive
member then he can go for visitation to his/her house.

Thanks for your help on how to make just to click the button the detail can
be expanded and collapsed.

--
H. Frank Situmorang

You can't put controls that do things into reports, only into forms.
Evi

Hello,

At the Report Footer I have a kind of statistics of membership query using
Total as follows:

TotalAll: Sum(IIf([JenisKel] Is Not Null,1,0))
TTLMale: Sum(IIf([JenisKel]="L",1,0))
TTLFemale: Sum(IIf([JenisKel]="P",1,0))
ActiveMale: Sum(IIf([STAT_CODE]="A" And [JenisKel]="L",1,0))
ActiveFemale: Sum(IIf([STAT_CODE]="A" And [JenisKel]="P",1,0))
PassiveMale: Sum(IIf([STAT_CODE]="I" And [JenisKel]="L",1,0))
PassiveFemale: Sum(IIf([STAT_CODE]="I" And [JenisKel]="P",1,0))

Is there any way to make a command button in this report footer to have:

Page header and Detail format Vision to Yes and then back to No>??

I appreciate for anyidea provided