Criteria strings, how many different criteria can be entered to retrieve specific data?

Posted by Janet on Super User See other posts from Super User or by Janet
Published on 2010-12-27T19:29:15Z Indexed on 2010/12/27 19:56 UTC
Read the original article Hit count: 290

Filed under:
|
|
|
|

For our membership database we are currently using an old DOS program "Arclist". The program is old but the one feature we desperately need in a database program is to be able to enter multiple criteria at one time for more of a "one time" extraction of the data meeting all the various criteria entered in what I call a "criteria string".
An example may be extracting only those records with zip codes matching (67893, 54235, 54323, 54201, 54302, 54303, 54301, 67894, 67895). Another set of criteria might be to omit records, not equal to, one type of criteria in one field and also extract records matching criteria in another field. So we would want records "not equal to" in one field, but whose information equals requested information in another field.

© Super User or respective owner

Related posts about multiple

Related posts about data-transfer