Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mikeyboy1

    Need to search for string in table and return count.. help!

    Thanks to all that responded. i ended using this function which counts the amount of delimeters. after getting the results i just counted the rows. Function xg_GetSubString(mainstr As String, n As Integer, delimiter As String) As String '* Get the "n"-th substring from...
  2. mikeyboy1

    search for string in table and return count

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

    Need to search for string in table and return count.. help!

    Thanks for the reply. Each record is one very long string ie: "W|W|UEPBX|3|23799|mike|Non-Designed|mike|NDS-SB|No" I am trying to get a total count of "mikes" in the column. I have been trying to create a function that will do it but have been at a loss..
  4. mikeyboy1

    Need to search for string in table and return count.. help!

    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!!

Part and Inventory Search

Back
Top