Jump to content

find in many fields


This topic is 8512 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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).]

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 8512 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.