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
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