Results 1 to 2 of 2
  1. #1
    Rasha is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2014
    Posts
    12

    a null value wanted to be added

    i design a report in design view and i insert text box that will add two fields together


    i found a problem that if one of these field have a null value the returned value is empty
    it can't add a number to a null value
    this is the formula which i wrote in the text box
    =[Medical Gases_CO2 - Carbon Dioxide]+[CO2_Items_Room]
    the problem is usually be in the first part of the formula
    any body can help me

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    Try:
    =Nz([Medical Gases_CO2 - Carbon Dioxide],0)+Nz([CO2_Items_Room],0)
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help Wanted..
    By cummings.ryan in forum Access
    Replies: 1
    Last Post: 05-12-2013, 07:53 PM
  2. Help wanted in SW Wisconsin
    By ldodge in forum Access
    Replies: 0
    Last Post: 06-30-2011, 06:21 AM
  3. a bar on the side not wanted
    By techexpressinc in forum Forms
    Replies: 4
    Last Post: 06-28-2011, 07:49 AM
  4. Crosstab Query Help Wanted
    By goodguy in forum Queries
    Replies: 19
    Last Post: 12-30-2010, 10:29 AM
  5. Programmer Wanted
    By Hoota Caroota in forum Access
    Replies: 2
    Last Post: 11-15-2010, 08:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums