title: MS Access 2007 Keyword search within form to generate report
body: <p>My Set-up: I have two tables: tblAuthors and tblBooks. tblAuthors includes a list authors: Kurt Vonnegut, Frank Herbert, J. K. Rowling, John Nichols, etc.. tblBooks includes a list of books: Slaughter House Five, Cat's Craddle, Monkey House, Dune, Harry Potter, Milagro Beanfield War, etc..</p>
  
  <p>tblBooks includes a memo coloumn called 'excerpts'. This section contains a small paragraph from each novel that has special significance or meaning.</p>
  
  <p>I have two forms as well: frmAuthor and frmBooks. frmAuthor includes the name of the author as well as some more author specific information that isn't particularly relevant to this question (date of birth, place of birth, preffered genre, inspirations, etc.). frmBooks includes the authors name(s) as well as some other information (publishing company, date completed, genre).</p>
  
  <p>I am currently using the filter function to generate reports within my forms. I am currently just using it to find simple stuff (Author name or genre). I was hoping that I would be able to generate reports by using the excerpt section from my form. I would like to be able to search a common word (e.i. God, Snake, Horse, Church, House, Road...) or phrase so that is within excerpt. That way I can generate a report with common themes.</p>
  
  <p>Please let me know if I need to clarify this at all, I know it may seem a bit convoluted. Thank you for your time.  </p>