Hi,

I am attempting to count in a portal but I¹m not getting the required
results.
I have 2 databases which are related by ID, and they are Assessor_name and
Samples. Each Assessor has an individual ID and each sample they do is
assigned that Assessors ID.
What I am trying to achieve is a running total for each Assessor of the
units they have sampled. For example, Joe Bloggs might have completed 10
samples. 5 of these are A, 3 are B and 2 are C. How can I programme a
calculation field to achieve this?

Thanks in advance,



Nick

In article <BF3A4FC9.937D%nick (AT) span (DOT) org.uk>,
Nick Marshall <nick (AT) span (DOT) org.uk> wrote:

Define a calculation field in the Assessor table, using the Count
function to count related Samples, thus:

Sample_This_Assessor = Count(Samples::AssessorID)

This will count the number of occurrences of the AssessorID in the
related Sample records.

You could use a different field in the Sample table (other than
AssessorID) as the basis for the count, just so long as every Sample
record has something in that field.

Bill

--
For email, remove invalid.