Results 1 to 2 of 2
  1. #1
    stalk is offline Competent Performer
    Windows 8 Access 2003
    Join Date
    May 2014
    Posts
    143

    How to make a report table dynamically with all the fields that have value greater than zero?

    I have about 38 fields in my table but only 7 or 8 fields will have value greater than 0 each time. I would like to generate the report with only those fields which has value zero or greater( Not null value).



    I need to generate a report with only positive value fields which will be about 8 to 9 fields at a time.

    Some of my fields are ..
    Public Const ct = "SRA1_Ct, SRA2_Ct, SRA3_Ct,P1_Ct,P3_Ct,P5a_Ct,P5b_Ct,PR_Ct," & _
    "P9_Ct, P5bV2_ct,EmN7_ct,NmH_ct,PV3_Ct,P5aV3_Ct,P10_Ct,P2_ Ct,P6_Ct,P10_Ct, P1V2_Ct"

    Any thoughts/ suggestions?

    Thank you

  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,518
    Sounds like you have a design problem. Normally you'd have records rather than fields, and you wouldn't have this problem. You'd only have records for the populated items.

    http://r937.com/relational.html
    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. How to make report fields export w/out tabs to Word/RTF file?
    By faithmarian in forum Import/Export Data
    Replies: 0
    Last Post: 12-10-2015, 04:33 PM
  2. Replies: 9
    Last Post: 11-04-2014, 08:06 PM
  3. Make OO Calc reports dynamically
    By garden in forum Programming
    Replies: 1
    Last Post: 07-08-2014, 10:07 AM
  4. Replies: 3
    Last Post: 04-09-2013, 09:32 PM
  5. Replies: 1
    Last Post: 12-09-2005, 10:29 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