One field to search multiple fields

[J. Williams]

I have one more question, then I'll give it a rest for a while... I promise.

I have three fields that could contain the information I am looking for, but don't want to have to search each individually... how might I create a new field to search the three?

As always, advance thanks for any help! JW

[comment]

You could use a calculation field (result is text) =

field1 & " " & field2 & " " & field3

But the need for this usually indicates incorrect data structure.

[J. Williams]

Tremendous thanks, that worked great!

I'm obviously a novice user, so can't say for certain I havn't structured my data incorrectly... I do have all three different project numbers (all relating to the same project) properly stored in their respective type fields; the problem is, the list of project numbers I received for research/reporting weren't identified as to type as they should have been, so instead of sending the list back, I thought I would figure out a way to resolve the situation.