February 17, 200620 yr 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
February 17, 200620 yr You could use a calculation field (result is text) = field1 & " " & field2 & " " & field3 But the need for this usually indicates incorrect data structure.
February 17, 200620 yr Author 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.
Create an account or sign in to comment