query using this criteria or that

P

papa jonah

I have a query that has multiple fields.
I want to select "*electr*" as criteria for two seperate fields in the
query. What I hope for is for records to show up with *electr* in one
or both of the fields. Instead none of the records are showing up.
There must be a way to do this that I am not trying. Any help would be
much appreciated. TIA
 
B

Brendan Reynolds

WHERE Field1 Like "*electr*" Or Field2 Like "*electr*"

Replace 'Field1' and 'Field2' with the actual names of your fields.
 
P

papa jonah

I am not sure what you mean. In design view for the query, the fields
have names.
The first one is "Type" and the second one is "Subreason".
 
L

Lost

In query design mode -

Put the criteria - Like "*electr*" in line1 under criteria
then put the same criteria in 'OR/line2' under criteria

hope this makes sense
 
B

Brendan Reynolds

In the 'Type' column, enter the criteria in the 'Criteria' row. In the
'Subreason' column, go down one row, and enter the criteria in the first
'Or' row.

If you enter the criteria on the same row in both columns, that is
interpreted as Type = criteria And Subreason = criteria, instead of Type =
criteria Or Subreason = criteria.

BTW: If you want to know what I meant in the earlier post, open your query
in design view, then choose SQL View from the View menu.
 
J

John Vinson

I have a query that has multiple fields.
I want to select "*electr*" as criteria for two seperate fields in the
query. What I hope for is for records to show up with *electr* in one
or both of the fields. Instead none of the records are showing up.
There must be a way to do this that I am not trying. Any help would be
much appreciated. TIA
Click to expand...

You can get OR logic (which is what you need here) by putting the
criteria for the two fields on two separate lines in the Criteria part
of the query grid. Or, you can switch to SQL view and use Brendan's
query - the SQL is "the real query", and the grid is just a tool to
help build SQL.

Just FWIW, it's worthwhile getting acquainted with SQL view; for one
thing, it's much easier to post queries in SQL to these newsgroups,
and for another, it's possible to do some queries in SQL view which
cannot be done in the grid.

John W. Vinson[MVP]
 
Top