Finding between fields

[tigergirl]

Hi,

I'm sure this is a basic question, but I can't figure it out. I would like to do a find that compares the values in two fields (for instance, work address 1 and preferred address 1) and comes up with those records that have the same values in the two fields. I'm doing this over a network, so I don't have the option of creating any new fields.

Thanks,

Tiger

[Lee Smith]

Have you tried using the "Exact function", it appears to be what you want.

Exact(original text, comparison text)

If the text match exactly, including length of text and uppercase and lowercase usage, the result is 1 (True). If the text do not match, the result is 0 (False)

You could then use the result of the calculation to do a find on.

HTH

Lee

[tigergirl]

Thanks Lee,

I think that would require that I create a new field for the "exact" function. Is there anything I can do without creating a new field?

[Lee Smith]

There isn't any function that I know of that can't be used in either a calculation or a script.

Here is a script that will find the Exact and Omit the Non Exact.

Go to Layout [

[spankalee]

Is there a way to do this in the find criteria and not with a calculation or script?

[Oldfogey]

I guess you can't define relationships, either?

If you can, define SelfJoin = Address1<->Address2

Place SelfJoin::Address2 on a layout and find the not empty ones.