find in many fields

[stac_1]

I have a need to search for a specific date in multiple date fields (6 of them) - one date - six fields to search in. That date should only appear once but it is possible that it could appear in any one of those six fields. Is there a way to search multiple fields?

Thanks in advance!

s.

[JerrySalem]

In the script make a new record/request for each date field to search.

Enter find mode

set searchdate1, 'date'

new record/request

set searchdate2, 'date'

perform find

this should work for you.

Jerry

[Vaughan]

Create a calculation field that joins up all the dates from the fields, separated by paragraph breaks. Then search the calc field.

[stac_1]

Jerry,

I have tried this and not had any success - can you give me a bit more info about this way?

Enter find mode

set searchdate1, 'date'

new record/request

set searchdate2, 'date'

perform find

Vaughn,

How do I then flag the matching/found set if they are all in the same field?

[stac_1]

Jerry. I still don't quite understand your suggestion, but the good news is that something worked!

Vaughan... Duh.... I got it! It worked like a charm!

Thanks so much for all of your help!

[This message has been edited by stac_1 (edited February 07, 2001).]

[JerrySalem]

a common prob with this technique is you have to make sure you have all of the fields on the current layout. (that is the date1, date2 etc) Otherwise the set field dosn't work.

If you don't want them on the layout for esthetic reasons, just make them all the same size and hide them behind something.