C
Chrissy
I calculate a field [NetDays] that is a function of the
result of dividing DateDiff [DaysTotal] by a number the
user inputs [NetDaysAdj]; I correctly get [NetDays]=
[DaysTotal]/[NetDaysAdj].
However, when I attempt to divide a currency field by
this, [RevPos]= [RevAmt]/[NetDays] I get $0. I suspect
[RevPos] as its determined by the results and differences
of two subforms as follows.
=[sfrmPostionGoal].Form!MoGoal
-[sfrmPositionStarts].Form!SumOfQuotedAmount
Both the above subforms return correctly as individuals
on the parent form.
I just cannot see what the problem is, nor can I
determine a workaround.
Can anyone help?
Thanks,
Chrissy
result of dividing DateDiff [DaysTotal] by a number the
user inputs [NetDaysAdj]; I correctly get [NetDays]=
[DaysTotal]/[NetDaysAdj].
However, when I attempt to divide a currency field by
this, [RevPos]= [RevAmt]/[NetDays] I get $0. I suspect
[RevPos] as its determined by the results and differences
of two subforms as follows.
=[sfrmPostionGoal].Form!MoGoal
-[sfrmPositionStarts].Form!SumOfQuotedAmount
Both the above subforms return correctly as individuals
on the parent form.
I just cannot see what the problem is, nor can I
determine a workaround.
Can anyone help?
Thanks,
Chrissy