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:
No luck
So i thought it might had something to do with the reference to the input form. So i tried :
But that didnt help either.
Am i doing it totally wrong?
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?