AnsweredAssumed Answered

Omitting records from find

Question asked by Andy on Apr 12, 2010
Latest reply on May 7, 2010 by Andy


Omitting records from find


My database has 2600 records with three key fields: Key 1 has "s" for spouses, Key 2 has "a" for dues paid members & Key 3 has "g" for registered for gathering.  I do a sort on Key 2 "a" and come up with 642 members.  From that I want to eliminate Key 3 "g" of which there are 157 and Key 1 "s" which has 248.  I did it manually by going through the 640 using "Omit record" "Ctl T" on each one but there must be an easier way to do this, especially when I will have to work with more than 640 records in the initial find.  Your help will be appreciated.

Andy (Svenska Woodworker)