First off, a little background info. I am a writer and I've created a databse using Access 2000 to store the words I've learned from reading other books so that I may use them when I write my own stories. My tables are solid and all have referential integrity enforced in their relationships. My problem is that I want to search the definition fields to see if they contain a particular word. For example I want to select the words whose definition(s) contain the word "blue". I know it sounds simple but I can't figure anything out. Can anyone push me in the right direction?

Nevermind. I figured it out.