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?