I don't know if you'd do it this way, but I would generate a filtered list of the words from every field, loop through that list and generate a query on the fly with 2 fields, words and count. If you need to establish the counts first before generating the query on the fly I would do that, then generate the query. Order the query by count and there you have it.
Ron Mast Webmaster Truth Hardware Ph: 507-444-4748 Fx: 507-444-5361 www.truth.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jake McKee Sent: Wednesday, April 06, 2005 8:19 AM To: [email protected] Subject: Re: Here's a new one... The data contained within the fields of this particular column is multiple words (sentences/paragraphs). I'd want to filter out certain things (like "I" or "an" or "the"). Jake PC Carraway wrote: > Does the DB column contain only one word per row or are there multiple > words per row? Please send a little more info. > > Precia > > ----- Original Message ----- From: "Jake McKee" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, April 06, 2005 8:47 AM > Subject: Here's a new one... > > >> OK, I've not seen this one discussed anywhere, so perhaps it's a new >> question... probably not. >> >> If I wanted to generate a report of some sort on which words in a >> particular DB column are used the most, how would I do that? >> >> Jake >> >> ---------------------------------------------------------- >> To post, send email to [email protected] >> To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm >> To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm >> >> >> > > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > > ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
