Finds across multiple fields and records

[jmichea]

Not sure if this qualifies as a basic question or not but here goes...

I am looking to do a find for an item that may appear in several different fields across multiple records. For example, I have a record with one section that contains 10 fields listing parts. I want to do a find that will find the name of the part in any or all of those 10 fields. Not sure how to do this.

Thanks

Jeff

[beverly]

Create a calculated field with these 10 fields.

field1 & " " & field2 & " " & field3 & ...

Then perform your find in this calculated field.

[beverly]

Create a calculated field with these 10 fields.

field1 & " " & field2 & " " & field3 & ...

Then perform your find in this calculated field.