Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    removing Null values & 0 values before printing (97)

    removing Null values & 0 values before printing
    My report is coming up with a smattering of #Num! And #Div/0 errors, sometimes both in the same column in my report. I have 3 levels of grouping so far, byDirector, byMediaEndDate & then a grandTotal. These errors appear in all these headers. I

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: removing Null values & 0 values before printing (97)

    You normally do this by setting the controlsource of the control to a formula that includes either an Nz() function to handle nulls or an IIf to handle conditions like a divide by zero. The latter would be something like this: IIf([MyDivisor]=0,0,[MyDividend]/[MyDivisor])
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: removing Null values & 0 values before printing (97)

    ok I fixed my problem Charlotte, I was improperly filling out my function! Thanks so much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •