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