lonesomejubilee Posted October 30, 2004 Share Posted October 30, 2004 Hi, I'm a newbie coming from MS Access so I'm used to writing queries. My question is I don't see how to count the number of occurrences in one field. For example, in one field I have a drop down selection of 16 choices. I want to be able to total how many occurrences of each of the 16 choices happen in one field. (i.e. 5 reds, 4 blues, 10 oranges... all in the field categor "color"). In MS Access I could write a query to do this and it would be easy... in FM I am still getting used to the Find... (which is nice to do certain things) Thanks... Vandy Link to comment Share on other sites More sharing options...
transpower Posted October 30, 2004 Share Posted October 30, 2004 Try this: PatternCount ( color ; "red" ), etc. for each class. Then, for the found set, you would want a Summary Field, Total of PatternCount ( color ; "red" ), etc. Hopefully, your colors are distinct! Link to comment Share on other sites More sharing options...
lonesomejubilee Posted October 31, 2004 Author Share Posted October 31, 2004 Can you elaborate a little on this... I'm sort of confused. Are saying make a field called patterncount ? I don't get it.... sorry I'm a newbie Link to comment Share on other sites More sharing options...
-Queue- Posted October 31, 2004 Share Posted October 31, 2004 The field would be a calculation using the function PatternCount, as Transpower has described. Link to comment Share on other sites More sharing options...
lonesomejubilee Posted November 1, 2004 Author Share Posted November 1, 2004 I'm sorry, I've never seen the PatternCount function before. Do I have to make a patterncount summary field for each category in the field? Then summarize it? Link to comment Share on other sites More sharing options...
-Queue- Posted November 1, 2004 Share Posted November 1, 2004 Each type will have an associated PatternCount calculation field and summary field, defined as the total of the calculation field. Link to comment Share on other sites More sharing options...
-Queue- Posted November 2, 2004 Share Posted November 2, 2004 Here's a quickly-assembled sample file for doing this using two repeating fields. Go to the Summary layout to see the results. Note that summary fields only act on the found set, so all records must be found before the totals will be accurate for the table. CountColors.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7113 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