Parameter query to select multiple child records on the same field

[David Wetmore]

I have a parent-child relationship where I want to be able to select all the children of the parent which meet multiple
criteria on one field. For example, for a parent name of "Big Creek" I want to be able to select all the child records
in which the map field contains "Dunsmore" AND those in which the map field contains "Cruso".

I have no trouble building a query which works for one child paramter value, "Cruso" for example, but the multiple
parameters on the same field have got me stumped.

Thanks, Dave

 

[John W. Vinson]

I have a parent-child relationship where I want to be able to select all the children of the parent which meet multiple
criteria on one field. For example, for a parent name of "Big Creek" I want to be able to select all the child records
in which the map field contains "Dunsmore" AND those in which the map field contains "Cruso".

I have no trouble building a query which works for one child paramter value, "Cruso" for example, but the multiple
parameters on the same field have got me stumped.

AND and OR look like the English language conjunctions, but they aren't: they
are actually Boolean algebra operators, just as + and - are arithmetic
operators.

You need to use OR in this case - because you want to retrieve the record if
it contains "Dunsmore", *or* if it contains "Cruso". AND would require that
each field contain BOTH values.

If you have trouble with this please post the SQL of your query.

 

[David Wetmore]

Thanks, the "or" did exactly what I needed.