September 22, 200619 yr Is there a way to find records where one field in the records equals another field in the record? The matching values will likely be different from one record to another.
September 22, 200619 yr Yes, there are many ways... for example you can create a new calculation field with this calc: field1 = field2 and search for records that have 1 inside that calc field.
September 22, 200619 yr Author For a fixed pair of fields, you're right of course. But is there a general way to do this with any pair of fields using Ctrl/F?
September 22, 200619 yr I don't think so, but you can make the calculation more flexible, e.g. GetField ( gFieldName1 ) = GetField ( gFieldName2 ) Of course, this needs to be unstored, so the find may take a bit longer.
Create an account or sign in to comment