Ok, so i have these two columns in my report.
Net Dollars 2002 [Sum of Net Dollars Oct 02 to Dec 02]and Net Dollars 2003 [Sum of Net Dollars Oct 03 to Dec 03].
And then I have a calculated field [Net Increase $] which is the difference between Net Dollars 2003- Net Dollars 2002. And finally...
PaulBricker, thank you for your help last week. it worked beautifully. thanks! of course, now i have another question.
How do we avoid #NUM! and #DIV/0! errors in a calculated field? My current syntax looks like this:
=IIf([Sum Of Net Dollars Oct 02 to Dec...
how do i used nested IFF statement in a report?
i have a calculated field in my report (Net Sales %) and I want to create another calculated field (Incentive Earned) using the data from Net Sales % field such that if Net Sales is between 10% and 20%, Incentive Earned is 1% times another field...
For some reason I have stopped being able to reply (or send) emails from my Yahoo and/or Hotmail accounts on IE. I can read messages, but just can't reply.
Am running XP Pro and IE 6. I uninstalled and reinstalled IE but the problem continues. I can reply/send Yahoo and Hotmail email from...
how do i get 0's instead of blank when I have a calculated field in a query?
I am calculating over two linked tables. For records that are not in one, I would like to get zeroes instead of blanks for further calculation. Any ideas?
(Is there a way to make calculated field created in a Query...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.