[IUG] Create list quandary

["Donna Campbell" <dcampbell at wts dot edu>]

Hi there,

I seem to recall that someone asked a similar question not too long ago
but I can find neither it nor any of the responses. Why does the order
of search parameters affect the number of hits for a query? See example
below:

Query #1
Store record type: order
Type = ORDER Field = Order Type Condition = equal to Value A = f
AND
Type = ORDER Field = Recv Date Condition = greater than or equal to
Value A = 07-01-2007
Number of hits: 1257

Query #2
Store record type: order
Type = ORDER Field = Recv Date Condition = greater than or equal to
Value A = 07-01-2007
AND
Type = ORDER Field = Order Type Condition = equal to Value A = F
Number of hits: 1264

Donna R. Campbell
Acquisitions and Cataloging Librarian
(215) 935-3872
(215) 887-3412 (fax)
Mailing Address:
Westminster Theological Seminary Library
P.O. Box 27009
Philadelphia, PA 19118
USA
Shipping Address:
Westminster Theological Seminary Library
2960 W. Church Rd. 
Glenside, PA 19038
USA