Counting Spaces

[needmoremoney]

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.

 

[TheBlondOne]

Have you tried using distinctcount instead of count??

HTH

 

[needmoremoney]

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