Calculated Field Counts Off

[Cozmo2]

I have a Calculated field that is set up for a Distinct Count the Perform Calculation on looks like this:

(query.prg_cod EQ "UNDERGRAD " AND query.level_ LTE "2" AND query.soc_sec)

Sometimes it counts the when the prg_cod is not equal to "UNDERGRAD " and sometimes it counts when the level is "3" or "4". It also counts the first record in the group regardless of the values.

I am using the Report Builder.

[Cozmo2]

Is there a better place to try to accomplish this? I have several different counts (Transferred, Level 1 or 2, Transferred Level 3, not Transferred Level 1 or 2, etc) and I do not want to write a query for each one.

[EddieLotter]

Yes, the better place to do this is on your database server.

See my response to your other question about calculated fields. The concept is the same.

Cheers

Eddie