Filtering data using a check box

Sniper-BoOyA-

Registered User.
Local time
Yesterday, 21:05
Joined
Jun 15, 2010
Messages
204
First of all, i'd like to say Happy New Year !

Secondly, i'd like to hear your guys' thought on how i could do this.

2-3 weeks ago, ive been making some forumulas to calculate averages. I ended up splitting the form, 1 for entering data and 1 for calculating the totals and everages.

There are 2 averages in total.

Now what i would like to do next is filter the averages on form2. In order to fix that, i was hoping i could use the checkbox, on the data entry form.

I added the following formula in the query:

Code:
Iif(checkbox1=True;average1;Iif(checkbox2=True;average2;"")

No luck

So i thought it might had something to do with the reference to the input form. So i tried :

Code:
checkavg: IIf(Forms!inputform!checkbox1=True;[Average1];IIf(Forms!inputform!checkbox2=True;[Average2];""))

But that didnt help either.

Am i doing it totally wrong?
 
When nesting IIF()s

IIF(A=True, 1,IIF(B=True,2,0))
 

Users who are viewing this thread

Back
Top Bottom