Confused...

[Fie]

Iam trying to do calcualtions in a report. The calcualtion i want to do
is same as on i have in excel, which is done in the Colour Bad filed (I
have text box in my report called txtcolband)

=IF(H5>=15,"Red",IF(H5>=10,"Red/Amber",IF(H5>=5,"Amber",IF(H5>=2.5,"Green",IF(H5>=0.01,"Blue","Black")))))


H5 = Vector Sum ( I have a vecotor sum text box on my report
(txtvetsum), this is a number entered buy the user) how do i preform
this calcualtion in a report???????


HELP

fie

 

[Fie]

thanks tonnes

 

[Baz]

Iam trying to do calcualtions in a report. The calcualtion i want to do
is same as on i have in excel, which is done in the Colour Bad filed (I
have text box in my report called txtcolband)

=IF(H5>=15,"Red",IF(H5>=10,"Red/Amber",IF(H5>=5,"Amber",IF(H5>=2.5,"Green",I
F(H5>=0.01,"Blue","Black")))))


H5 = Vector Sum ( I have a vecotor sum text box on my report
(txtvetsum), this is a number entered buy the user) how do i preform
this calcualtion in a report???????


HELP

fie

Replace "H5" with "txtvetsum", replace "IF" with "Iif", and paste the
resulting formula into the ControlSource property of txtcolband.