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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Counting Spaces

Status
Not open for further replies.

needmoremoney

Technical User
Mar 30, 2005
123
US
Hello All,

I have this to count records from a Detail section of a Group setting:
stringvar TotString:="";

TotString := "T4" + {@TotalEEs} + {@TotalSpaceFill} + chr(013);

TotString;
................
the formula for the TotalEES is :

numbervar reqlength := 11;
stringvar string := totext(Count ({@EESSN}, {Query1.id}), "00");
numbervar currlength := length(string);

if currlength > reqlength then
string := string[currlength - reqlength]
else
string := replicatestring("0", reqlength-currlength) + string;
.............


My problem is that I suppress duplicate values, the formula above counts them as well. Is there a way to not include the supressed, duplicate values in my count formula?

Thanks for any response.
 
Thanks BlondOne. I forgot about that one. It works fine now. Much thanks again.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top