Question about a search query (primary and Secondary search)

P

Pierre Martinez

I have been tasked with going through a few people's PSTs in order to find
word search matches for specific criteria.

First I started by exporting the PST into Access format -it does a great job
in creating the fields and populating the data, now I need to create a query
in order to find the primary search match as in the table below
i.e."house" -if I find "house" in one of the emails -then I would proceed
and do a secondary search in the remaining of the other secondary search
words i.e."man" "actual" "forbid" ,etc.

Once that completes, I would repeat the process for the second primary
search word "spending".

Anyone has any clue how to design a query like this with secondary
searches -a

any feedback will be appreciated.

thanks

Primary search Secondary Search

house man
spending actual
forbid
 
Top