RET Posted December 29, 2000 Posted December 29, 2000 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
PinnWal Posted December 29, 2000 Posted December 29, 2000 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 :-)
Recommended Posts
This topic is 9000 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now