Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FormulaHELP ASAP

Status
Not open for further replies.

pgtek

Programmer
Sep 28, 2001
1,180
CA
Hello,
Can you help me please, heres my problem
i have a group call district and in this group i list multiple district
each district has 4 field (number)
Group Name MONROE
text GENERAL field name value 122
SPECIAL 0 (*)
LIMITED 2
TOTAL suppress 124 to show (*)
so they cant had the numbers to have the TOTAL value

Group Name JOHNSON
text GENERAL field name value 122
SPECIAL 4
LIMITED 2
TOTAL 128
now there are no 0 or null value assing to then show the TOTAl value

Group Name WADE
text GENERAL field name value 99
SPECIAL 0 (*)
LIMITED 0 (*)
TOTAL 99
now i have more than one 0 or null value then Show the TOTAL value

NOTE: EACH OF THESE FIELDS NUMBERS ARE THE SAME NAME ASSIGN TO EACH DISTRICT BUT CONTAINS DIFFERENT VALUE IN REPECT OF THE DISTRICT NAME

if one of these field is 0 or is null suppress it and replace with a (*)
now heres the tricky part
if one of these field is 0 or is null then the TOTAL field replace it with a (*) so the cant add the sum of these field to have the TOTAL value
else if
i have more than one (*) or 0 then show the value of TOTAL
now remember that i have multiple district and all have diferent value not all district have 0 or is null assing to the repected field
I just want to replace the distinct districts that has the 0 or is null value

thanks

PG
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top