I would like to see if I could create a field that will give me a running count of record used in a cretin field.

Example: I have a value list with "boy", "cat", "dog" in it. I would like this NEW field to contain a running total of all the records that are using "boy", totaling with a Number. So if "boy" were used in 6 of my records this field would contain the number 6.

Can this be done?

Thanks,

RET

Here's one possibility:

Create three Calc fields -

Case(Value="boy", 1, 0)

Case(Value="cat", 1, 0)

Case(Value="dog", 1, 0)

then create three Summary fields that get the total of each of the three Calc fields.

Later :-)