Field value!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to share a value by percentages to three fields. One of these
three fields' value must be a calculation if another field satisfies a
condition, else 0 must be the value in this field. How can I go about that,
(in the report?)

Thany you.
 
Well its funny but I'm glad I've been able to find a solution to my problem...

What I did was to actually do this calculation in the query then I'll just
let the report grab the source from the query.

I used the Iff("Expr","True value", "False value"), in the field I was
talking about, and it is working perfectly.

I hope this helps anyone trying to find a solution to this or a similar
problem. It feels great.

If there are other ways kindly post them as well.

Thank you.
 
Back
Top