Search results

Hi all, Im trying to get the number of records under the value of 6 , eg. On the report it looks like this Date Result 1 5.6 2 3 8.2 4 6.6 5 4 6 7 10And...

=IIf([Result1]<4.1,0, IIf([Result1]>6.5,([Result1]-[Pump Settings]![Target]), IIf([Result1]>4<6.5,1,""))) 1) from that I would say that there should be 4 brackets not 3, but with 4 i get an error 2) the part ([Result1]-[Pump Settings]![Target]) should not be in brackets the formula works if...

Hi all, Below is the formula that I'm trying to get a value from an other Form (Pump Settings). But I keep getting an error message . :banghead: =IIf([Result1]<4.1,0,IIf([Result1]>6.5,([Result1]-[Pump Settings]![Target ]),IIf([Result1]>4<6.5,1,""))) Can anyone help ? Thanks

Hi all, I need to get an averge of 2 variables eg. target low eg 4 target high eg 8 target (to have the avg) result 6 i have been doing the following but dont work .. =Avg([Target Low].[Target High]) result #error =Avg([Target...

Hi all, Is There Anyway to Make a Settings Page in accrss , so that i can put in data that changes 1 or 2 times a year, but affects loads of formulas thanks john