text occurance

[puthenveetil]

Hi all,

Can we track the number of times a specific word appeared in a field on a report. I mean In a report I had a field which shows a or b or c for each records...is there any way to count howmany times these texts appeared..

like if a had shown in 3 records the count should be 3 like that....


Thanks in advance

Thanks

 

[reclusivemonkey]

I know there is a COUNTIF function in Excel, but it doesn't seem to be included in Access. Just off the top of my head, is is possible to group the report on the criteria you are wanting to count? If so, then you could group your report so that all the 'a's are in their own group and simply include a COUNT([Field]) in that groups footer. I am assuming you can tweak your report layout; its hard to advise without knowing any more. Lets us know if that helps.

 

[puthenveetil]

Hi ,

thanks for the tip..that worked...

Thanks