Results 1 to 2 of 2
  1. #1
    cfobare79 is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Dec 2014
    Posts
    66

    Formula in a textbox


    The formula below works fine when there is data for both Textboxs. The problem is when the second Textbox is null. Text150 is a sum in the Main Report, Totals1 is a sum in a subreport.

    =[Text150]+(IIf(IsNull([VerizonReport].[Report]![Totals1]),0,[VerizonReport].[Report]![Totals1]))

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    If it's a subreport:

    nnz function
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 41
    Last Post: 05-29-2015, 02:58 PM
  2. Replies: 2
    Last Post: 01-08-2014, 05:18 PM
  3. Replies: 2
    Last Post: 04-20-2013, 03:37 AM
  4. Replies: 8
    Last Post: 04-12-2013, 08:59 PM
  5. Replies: 17
    Last Post: 02-08-2012, 10:06 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
  •  
Other Forums: Microsoft Office Forums