Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NoviceNYC

    Nested iff in Report

    Remember I am a NoviceNYC? How does one give a star? [2thumbsup]
  2. NoviceNYC

    Nested iff in Report

    Yes, $QNI% is the calculated text book and yes, you are a genius. Thank you for all your help!
  3. NoviceNYC

    Nested iff in Report

    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...
  4. NoviceNYC

    Nested iff in Report

    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...
  5. NoviceNYC

    Nested iff in Report

    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...
  6. NoviceNYC

    Can't send/reply to Yahoo or Hotmail emails

    When I click the Send button, I get waiting to contact http://us.f414.mail.yahoo.com/ym/... and it eventually times out.
  7. NoviceNYC

    Can't send/reply to Yahoo or Hotmail emails

    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...
  8. NoviceNYC

    Filling 0s instead of blank in Query

    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...

Part and Inventory Search

Back
Top