How do I get criteria in a query to pull information from two set.

G

Guest

I have a field set up that allows users to enter multiple data for searches
(or so I thought). The field is called Category and has information put in
(example) HEQ, PBH5, PBH6 -- etc. When I use the query in that field to
find either PBH5 or PBH6 it doesn't find the data. My criteria is: Like
"PBH5*" Like *PBH6* - but it doesn't find it. I've tried everything I can
think of, and HELP isn't a lot of help in this case!
 
G

Guest

hi,
it would help if you posted the query's SQL.
are you doing this from a form? combo box?
in the criteria pane, it should like like this
like "*PGH5*" or like "*PBH6*"
but without knowing how you are getting the criteria into
the query, i can give little advice.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query To Pull Null Value 5
ALL criteria in a query 1
Query with mulitple optional criteria 4
"All" in query criteria 4
Query Criteria from a Selection 2
How do I set criteria for calculated total fields in a query? 1
Query Criteria Problem 1
Passing Criteria to a Query 8

Top