AnsweredAssumed Answered

Count unique records

Question asked by wcallman on May 11, 2018
Latest reply on May 12, 2018 by wcallman

I have a database where a record has to be relocated every time there is a data change, required by grant funding guidelines. this is not the problem, that is easy to do. I need to display a unique record count, 1 client can have

ten records,  etc.

I have reviewed and implemented multiple solutions, to no avail, the one I like the is PhilModJunk's

simple: Count(UniqueValues (FML Name)   ), he used a different expression than (FML Name), where FML

is concatenate of first mid init and last name. When entering the formula an error message pops up saying:

"In the function Average, Count, . . . . ., an expression was found where a field alone is needed."

 

What am I doing wrong?

Outcomes