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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Situmorang - 09 Apr 2008 09:36 GMT

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

Signature

H. Frank Situmorang

Reply to this Message

Evi - 09 Apr 2008 22:04 GMT

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

> Hello,
>
[quoted text clipped - 17 lines]
> --
> H. Frank Situmorang

Reply to this Message

Frank Situmorang - 10 Apr 2008 03:59 GMT

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.

Signature

H. Frank Situmorang

> You can't put controls that do things into reports, only into forms.
> Evi
[quoted text clipped - 19 lines]
> > --
> > H. Frank Situmorang

Reply to this Message