Can anyone figure out what is wrong with the below expression?
=IIf([Vist / Raised Date]>"30/04/2007",[Project Eng Hrs]*58.74+[Install Hrs]*21.84+[Mat £],[Project Eng Hrs]*48.85+[Install Hrs]*19.49+[Mat £])
The field should return me the sum of the project engineer's labour, installation labour and materials cost - if after 30-04-2007 then at the first rates, if before then with the lower rates.
The results are always coming back with the old lower rates.
Each year the IIf statement will need to grow to take in the new rates.
=IIf([Vist / Raised Date]>"30/04/2007",[Project Eng Hrs]*58.74+[Install Hrs]*21.84+[Mat £],[Project Eng Hrs]*48.85+[Install Hrs]*19.49+[Mat £])
The field should return me the sum of the project engineer's labour, installation labour and materials cost - if after 30-04-2007 then at the first rates, if before then with the lower rates.
The results are always coming back with the old lower rates.
Each year the IIf statement will need to grow to take in the new rates.
That's why we're here!
