Search an Access Database

Results 1 to 2 of 2

Thread: Search an Access Database

  1. #1
    JB Guest

    Default Search an Access Database

    What I am trying to do is search a table I have that has 2 coloumns, name and status. What I want to to do is search this table for all instances of the word "Down" and then return the number of Down&#039s that it found. I can&#039t get this too work.<BR>I have read as many articles on how to search an Access databse for a search engine as I could find, but so far everything I have tried isn&#039t working. Any help would be greatly appreciated.

  2. #2
    Join Date
    Dec 1969

    Default RE: Search an Access Database

    &nbsp;<BR>Select * From Table Where nam Like &#039%" & Variable & %&#039 Or Status Like &#039%" & Variable & "%&#039"<BR><BR>Open the recordset then get a recordcount<BR><BR>Response.write There were " & RS.RecordCount & " Records Found"<BR>RS.Close<BR>Set RS=Nothing<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts