Forgot password? | Forgot username? | Register

Querying *within* a set of records?

Querying *within* a set of records?

Does anyone know if there is a way to restrict a query to search only within a certain set of records? For example, if I save a set of 100 records as a group, and I want to search within those 100 records for some value?

Of course I could just retrieve the group and then do an "Additional Search" for the desired value, but that would first search all records in the module before reducing it to just ones in my saved group. This can take a very long time for a wildcard search, when all I'm really interested in searching are those 100 records in the group.

Thanks,
Tom Trombone
Division of Vertebrate Zoology - Ornithology
American Museum of Natural History
Thomas J. Trombone
American Museum of Natural History

Thomas Trombone
Data Manager, Ornithology
useravatar
Offline
54 Posts
Male  Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Querying *within* a set of records?

I've found that pasting the IRNs from your first search into a new search with the additional criteria processes much faster than "additional search".  I also realize this is a very old post.


Bill Mertz
Database Manager
useravatar
Offline
22 Posts
Male  Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Querying *within* a set of records?

An old post but a useful suggestion. Thanks!

In the ensuing (gulp) nine years I have come to use IRNs as you suggest. On occasion I've also taken to doing a quick export on a set of records and then importing them into Microsoft Access to perform some more complicated queries. May not be elegant but it works.

Tom Trombone
AMNH Ornithology

Thomas Trombone
Data Manager, Ornithology
useravatar
Offline
54 Posts
Male  Website 
Administrator has disabled public posting. Please login or register in order to proceed.
There are 0 guests and 0 other users also viewing this topic