Caculate Text

  • Thread starter Thread starter JT
  • Start date Start date
J

JT

I have a field the holds text values.
I'd like the report to count how many times the word
appears for a specific field. any suggestion
 
Insert an extra field into your Table with the Name "Qty".Assign a default value of "1" to it.You can then use this field to count the records you select,lets say in a report.If you need help,reply and give me more info,e.g. do you want to use it in a report,a form,where?
 
Questions.
Do you mean to count the number of records with a specific word in a field?
If so, can the word appear more than once in the field? And if it does, do you
count this record once or one time for each appearance of the word?

Or does the field hold just one word?

Or do you want to count the number of times the word appears in one field in one record?

Does the word have to be a whole word. Wholesale vice Whole. If I am looking
for Whole, do I count Wholesale?

It does make a difference on how to answer the question.

Simplest case.
SELECT Count(SomeField) as CountRecords
FROM SomeTable
WHERE SomeField = "Argue"

Count records where a word appears one or more times as one word or as part of a
word in the field in a record.

SELECT Count(SomeField) as CountRecords
FROM SomeTable
WHERE SomeField Like "*Argue*"
 
Back
Top