Finding across multiple fields

[RayRay]

Thanks - it worked like a charm.

[RayRay]

I am trying to set up a database for videotapes and have set up each record to be a videotape. Since each tape(record) can have multiple programs on it, I have set up individual fields for each program (i.e. program01, program02, thru program50). I need to find a way to search for a tape(record) that could have a program in any of the 50 'program' fields. For example, 'Ski Trip' may be a program on several tapes - it may be in field 'program05' in one record and in field program45' in another record. How can I search for all records that contain 'ski trip' in any of the 50 'program' fields?

In other words, I'd like to be able to find records that match criteria across a number of different fields.

Thanks.

[Kurt Knippel]

quote:

---

Originally posted by RayRay:

I am trying to set up a database for videotapes and have set up each record to be a videotape. Since each tape(record) can have multiple programs on it, I have set up individual fields for each program (i.e. program01, program02, thru program50). I need to find a way to search for a tape(record) that could have a program in any of the 50 'program' fields. For example, 'Ski Trip' may be a program on several tapes - it may be in field 'program05' in one record and in field program45' in another record. How can I search for all records that contain 'ski trip' in any of the 50 'program' fields?

---

Setup a calculation which combines all of the program fields into one, seperated by paragraph return.

Then just perform your find on this one field.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

[ROBVOIGT]

How do you separate fields using paragraph return?