Solved Counting Checkboxes with True Value

[basilyos]

hello i have 4 checkboxes in continuous form
i want to get the sum of each checkbox with true value in an unbound texbox
i tried these codes

=Sum(IIf(Nz([chk_Gift];False); 1; 0))

=-Sum([chk_Gift])

=Abs(Sum([chk_Gift]))

but always am getting error any help please

 

[CJ_London]

What is the error description?

 

[Pat Hartman]

=Abs(Sum([chk_Gift]))

This is the correct syntax. The control belongs in the footer of the continuous form.

 

[basilyos]

What is the error description?

when i run the form am getting just #error

 

[basilyos]

This is the correct syntax. The control belongs in the footer of the continuous form.

i already putting the codes in a textbox in the form footer but the three codes return #error

 

[The_Doc_Man]

This would occur if for some reason the field [chk_Gift] is not visible in that context. Is the field chk_Gift part of the .RecordSource of the form?

 

[basilyos]

This would occur if for some reason the field [chk_Gift] is not visible in that context. Is the field chk_Gift part of the .RecordSource of the form?

the chk_Gift is visible and yes it's part of the record source

 

[CJ_London]

perhaps time to upload a copy of your db

 

[basilyos]

Hey Guys this is a mini copy of my database just one table and the form where am facing the problem

thanks in advance

 

[mike60smart]

Hey Guys this is a mini copy of my database just one table and the form where am facing the problem

thanks in advance

It would help if you used the actual Control names as shown below:-

 

[basilyos]

Ohhh am really an idiot
I typed the name of the name of the control not the control source

Am really sorry and thanks

 

[CJ_London]

think you mean field names

 

[mike60smart]

think you mean field names

Whoops. Sorry.