One thing you could try is to break your expression apart and just get
one value at a time. If that expression works then add the next
expression to it.
=(DateDiff("d",(IIf([End Date] Is Null,#31/03/2007#, [End
Date])),[Forecast Date])/7)*[Weekly Impact]*-1
try enclosing the -1 in parentheses. I think the code is interpreting
this
[weekly impact] * - 1
instead of
[weekly impact] * (-1)
Or
(DateDiff("d",(IIf([End Date] Is Null,#31/03/2007#, [End
Date])),[Forecast Date])
/7)
you are getting a difference of days and dividing that by 7. Then you
are multiplying this value by a value contained in [weekly impact]
*[Weekly Impact]
then it appears you want the total value to be negative. If you enclose
(-1), then this is what the computer would interpret.
*
(-1)
Try breaking each expression apart to see if you get the desired value.
Start with the difference of days. If you get the correct result then
try adding the divide value by 7 part. If that gives a correct result
then add the * [weekly impact]...
Rich
*** Sent via Developersdex
http://www.developersdex.com ***