Results 1 to 2 of 2
  1. 10-08-2014, 06:53 AM #1
    jenncivello
    jenncivello is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    36

    Adding null fields


    I have a query that has some blank fields and at the end of the query is a calculated field. How to i get the calcutaed field to show the total even if some of the fields are left blank?
    Reply With Quote Reply With Quote
  2. 10-08-2014, 06:56 AM #2
    JoeM
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    What exactly is the calculation?
    You may be able to use the NZ function to convert those nulls to zeroes, i.e. http://wheatblog.com/2008/05/the-mys...rosoft-access/
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Formatting a report - adding fields, adding sub totals, separating data
    By boulderer in forum Access
    Replies: 1
    Last Post: 08-06-2013, 07:52 PM
  2. Prevent user from adding subform record if main form has null value
    By Jojojo in forum Forms
    Replies: 2
    Last Post: 12-07-2011, 02:51 AM
  3. Combine two fields, Null fields involved
    By yes sir in forum Access
    Replies: 9
    Last Post: 10-03-2010, 09:20 AM
  4. primary keys, cannot contain null value, Adding Records to a form
    By kevin007 in forum Forms
    Replies: 1
    Last Post: 08-03-2010, 01:33 PM
  5. VBA to update matching fields from one table and set unmatching fields to null
    By KP_SoCal in forum Programming
    Replies: 5
    Last Post: 03-20-2010, 08:30 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums