Counting Comments

P

PeterM

I have a memo field on a form. I need to count the number of specific
occurrances of a text string within the comment. The values in the comment
field are in no particular order.

Comment field would have
11/7/2005
11/7/2005
11/4/2005
11/5/2005

I need to determine that for 11/7/2005, the count is 2, and for 11/5/2005
the count is 1 and for 11/4/2005 the count is 1.

Is there a way to do this via a form or SQL statement?

Thanks in advance for your help!
 
D

Douglas J Steele

Are you saying that those 4 dates are contained in the same memo field?
There's no way you're going to be able to count them using SQL. You'll have
to write a VBA function (which you could, of course, then call from SQL),
but unless there's something in the text that clearly delineates each date,
it'll be quite slow.
 
Top