Boolean Logic Search Capabilities

[#1]

We are a Temporary Staffing Service. We use ACT to track resources currently on Payroll, Assignment with other employers and those Currently Available. We can invoice directly from ACT as well as complete a multitude of other administrative task.

We leverage the power of the Groups function to quickly narrow the employment category. From there, if a specific skill or set of skills are sought, we need to use the Advanced Look Up query. It works but takes a long time to build.

I would love if ACT could provide the search functions similar to those of Boolen Logic. Boolean Logic is nothing more than the language used to tell computers exactly what we are looking for. It is a series of commands and operators that combine keywords into meaningful phrases for our search engines. Let’s take a look at the basic commands AND, OR, AND NOT and NEAR and the three basic operators; quotes, parentheses, and wild

card.

It's very similar to the Advanced Look Up but is much more user friendly.

Anyone have any ideas?

[#2]

Hrmmm... just to clarify, you'd like to be able to do those sort of searches with boolean operators against a specific field, or?

[#3]

Have you tried Google Desktop? I haven't, so I can't say that it would even work, however if it does then I imagine it would meet your needs well.

[#4]

The ideal scenario would be to search within the Notes field/Tab only. There I could paste the resume. Each file would have only one resume pasted in the tab.

From anywhere in ACT, we could select an icon, say a search icon. We then type in our criteria and it would run (looking for info in the in the Notes tab only).

The rest would remain the same as an advanced query (preview, create look up, etc.)

ACT is based on SQL and SQL has the same logic and operators as Boolean. Here's an article which explains SQL searches in full. http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

I don't understand why ACT won't index it's tables. An already good CRM would be so much more powerful.