DCOUNTA search in field for value

P

Paul Dennis

I have a field which is text and I need to search within it for a value
within my DCOUNTA.

Is this possible? How?
 
P

Peo Sjoblom

Yes it certainly is

for example if the strings can look like


"Horse meat is good"

"You have to go to Canada to have horse meat if you live in the US"

"The Congress critters won't allow Americans to eat horse meat"


and you want to count "meat"


use this

="=*meat*"
 
Top