search for string in table and return count

[Guest_imported]

I need help!! I have a table in which im trying to find the count of a string in a specific column. In other words, im trying to count how many times "mike" shows up in a specific column.Can anyone help!!

 

[FoxProProgrammer]

The easiest way to do this is with the DCount function.

Dim numRecs As Integer

numRecs = DCount(fieldname, tablename, fieldname = "mike&quot dz
dzaccess@yahoo.com

 

[mikeyboy1]

thanks for the response. But i actually I am trying to get a substring. The field is one long string ie" xxx|xxx|xxx".

 

[FoxProProgrammer]

Ah, sorry I misunderstood your question. Do you want to do this for a specific record in the table or for all records? In other words, do you want to count the number of occurrences in each record and sum them together, or find a record and count the number of occurrences in that one record? dz
dzaccess@yahoo.com