is there any way to compare two fields

[saralee]

In the Find mode, is there any way to search for records with two fields identical?

For example, searching for records which have field A and field B with exactly the same content.. or field A and field B that do not share the same content..

Does "?" do the trick?

Edited August 11, 2010 by Guest

[bruceR]

No.

[Lee Smith]

Hi saralee,

I don't think we have enough information to provide much assistence.

Why not enclose a copy of your file.

Even a detail description of the circumstance might help.

Please do not use generic fields, files and layouts. Field A and Field B mean nothing to us, as we can't tell if they are in the same TO, or in different TOs. We can not tell if they are on the same layout, we do not know if there is a relationship, etc.

Lee

[LaRetta]

In the Find mode, is there any way to search for records with two fields identical?

When comparing two fields, you will need a calculation which compares the two fields (producing a boolean true if they mismatach) and then search for 1 in this calculation.

If this is something you wish to do regularly and you want to compare many fields, you can handle it this way (see attached).

Note that fields you want to consider (have appear in the pop-up for field selection) need to be placed on the Developer layout. Also note that this calculation is an unstored calc whereas a calculation just using two local fields would be stored so the unstored calc would be slower over larger record sets.

BruceR, gee whiz ... You should not respond at all if you are not going to assist. Your answer did nothing but spit.

Get.zip

[saralee]

Thank you all so much!! I have better idea now.