Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

#Error in reports

Discussion in 'Information Technology' started by danlock2@gmail.com, Jul 28, 2006.

Tags:
  1. danlock2@gmail.com

    danlock2@gmail.com
    Expand Collapse
    Guest

    I have a report that has some null values so it shows #error, is there
    any way to get around this with code so that like the #error = 0?
     
  2. Loading...


  3. BruceM

    BruceM
    Expand Collapse
    Guest

    Check Help for information about the Nz function. In your situation you may
    set a text box control source to:
    =Nz([YourField],0)
    Or it may be in a query, or VBA. Your question is short on details, but Nz
    is the way to proceed.

    <danlock2@gmail.com> wrote in message
    news:1151681924.790703.131480@m73g2000cwd.googlegroups.com...
    >I have a report that has some null values so it shows #error, is there
    > any way to get around this with code so that like the #error = 0?
    >
     
  4. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Hi Dan

    Press F1 (help) and search on Null values or Nz

    I just copied this of the help site.
    The Nz function is useful for expressions that may include Null values. To
    force an expression to evaluate to a non-Null value even when it contains a
    Null value, use the Nz function to return zero, a zero-length string, or a
    custom return value.

    Hope this helps

    --
    Wayne
    Manchester, England.



    "danlock2@gmail.com" wrote:

    > I have a report that has some null values so it shows #error, is there
    > any way to get around this with code so that like the #error = 0?
    >
    >
     
  5. danlock2@gmail.com

    danlock2@gmail.com
    Expand Collapse
    Guest

    the way that the field is calculated is through adding all the sums of
    a few columns in a table, inside of a function, is it possible to call
    a function inside of NZ()? This is in access.


    BruceM wrote:
    > Check Help for information about the Nz function. In your situation you may
    > set a text box control source to:
    > =Nz([YourField],0)
    > Or it may be in a query, or VBA. Your question is short on details, but Nz
    > is the way to proceed.
    >
    > <danlock2@gmail.com> wrote in message
    > news:1151681924.790703.131480@m73g2000cwd.googlegroups.com...
    > >I have a report that has some null values so it shows #error, is there
    > > any way to get around this with code so that like the #error = 0?
    > >
     
  6. BruceM

    BruceM
    Expand Collapse
    Guest

    Did you check Help for information about Nz?

    <danlock2@gmail.com> wrote in message
    news:1151683984.223389.229420@i40g2000cwc.googlegroups.com...
    > the way that the field is calculated is through adding all the sums of
    > a few columns in a table, inside of a function, is it possible to call
    > a function inside of NZ()? This is in access.
    >
    >
    > BruceM wrote:
    >> Check Help for information about the Nz function. In your situation you
    >> may
    >> set a text box control source to:
    >> =Nz([YourField],0)
    >> Or it may be in a query, or VBA. Your question is short on details, but
    >> Nz
    >> is the way to proceed.
    >>
    >> <danlock2@gmail.com> wrote in message
    >> news:1151681924.790703.131480@m73g2000cwd.googlegroups.com...
    >> >I have a report that has some null values so it shows #error, is there
    >> > any way to get around this with code so that like the #error = 0?
    >> >

    >
     

Share This Page