Cazito Posted January 21, 2011 Posted January 21, 2011 Hi guys. Suppose I have a field called Fruits and ten records on my database like this: 1 Orange 2 Orange 3 Apple 4 5 Orange 6 Grape 7 Apple 8 9 Strawberry 10 Grape I'm looking for a summary field that would return unique instances of Fruits which in the example above would be 4. I was thinking of creating two fields. A calculation field that would return zero, if the Fruit field is empty, one for the first instance of each fruit and zero for the remaining fields. Then I could use a summary field Total of or Count of to get the result I want. Any suggestions? Thanks in advance.
Recommended Posts
This topic is 5053 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