ABCRobstown Posted February 12, 2007 Share Posted February 12, 2007 I have a field with three possible entries: U, M, or ALT. I would like to have a count of each of the three entries--for example, 10 U's, 15 M's, 8 ALT. Is this possible? I am using both FMP4 and FMP6. Thanks in advance for your help. Link to comment Share on other sites More sharing options...
Genx Posted February 12, 2007 Share Posted February 12, 2007 Does the patterncount function exist in fp4 / fp6? Link to comment Share on other sites More sharing options...
mr_vodka Posted February 12, 2007 Share Posted February 12, 2007 Does the patterncount function exist in fp4 / fp6? Yes it does Alex. Link to comment Share on other sites More sharing options...
Genx Posted February 12, 2007 Share Posted February 12, 2007 Lol, well you could've taken it from there John : PatternCount(textField ; "U" ) & " U's " & PatternCount(textField ; "M" ) & " M's " & PatternCount(textField ; "ALT" ) & " ALT " U, M, or ALT. I would like to have a count of each of the three entries--for example, 10 U's, 15 M's, 8 ALT. Link to comment Share on other sites More sharing options...
Ted S Posted February 12, 2007 Share Posted February 12, 2007 You know, I'm not sure you fellas are answering the question that he intended to ask. The title of his post makes me think that you've answered correctly but the wording in the body leads me to think that he may really want to know how many *records* have the value "U" and how many *records* have the value "M" and how many *records* have the vaule "ALT". Maybe I'm wrong. Link to comment Share on other sites More sharing options...
Genx Posted February 12, 2007 Share Posted February 12, 2007 Hmmm, maybe, but they'll need patterncount either way. Link to comment Share on other sites More sharing options...
Ted S Posted February 12, 2007 Share Posted February 12, 2007 ... but then again, he put the post in the define fields category so you're probably correct. Forget my blabbering. I'll shut-up now. Ten-Four. Over-and-out. Good bye. Link to comment Share on other sites More sharing options...
Genx Posted February 12, 2007 Share Posted February 12, 2007 And what's wrong with giving whiskey and car keys to teenage boys... maybe not both at once but.. Link to comment Share on other sites More sharing options...
ABCRobstown Posted February 13, 2007 Author Share Posted February 13, 2007 Thanks for the help. You put me on the right track. Here's how it was settled. First total field: PatternCount(TAKS Lvl 2, "Alt") Second total field: PatternCount(TAKS Lvl 2, "M") Third total field: PatternCount(TAKS Lvl 2, "U") Link to comment Share on other sites More sharing options...
Genx Posted February 13, 2007 Share Posted February 13, 2007 :) Link to comment Share on other sites More sharing options...
mr_vodka Posted February 13, 2007 Share Posted February 13, 2007 Lol, well you could've taken it from there John Sorry Alex, : I was half brain-dead yesterday (I'm brain-dead to begin with so that doesnt leave much room). I didnt get any sleep because of a really early flight. Link to comment Share on other sites More sharing options...
Genx Posted February 13, 2007 Share Posted February 13, 2007 Okey :) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6282 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