Query "something" or "somethingelse" 1

[simoncpage]

Does anyone know how to do a search on two fields to query 1 field for 1 value and another field on another. Basically I have an contact file that has address1 and address2 and it would be nice to be able to search for street names in either???

any help would be great

Thanks

Simon

 

[phaeberle]

Create a calculation field and concatenate both, address1 and address2 (address1 & " " & address2).

When entering in find mode, change layout and perform the search in the calculated field, not in address1 or address2

 

[Schlogg]

You are joking re you not?
Enter Find mode
enter 'Railway' (say) in Address1
hit CTL-N
enter 'Railway' in Address2
perform find.
You will find records with 'Railway' in either Address1 or Address2 or both.

Cheers,
Paul J.