problem with 'in' operator in select query

G

Guest

there is a problem with 'in' operator in select query

sometimes select query does return all the rows if used 'in' operator in
`criteria.

for ex. Select * from modelmaster where model in ('a','b','c')
sometimes will return partial recordset. (most frequent with complex queries)

I hope I will get someone for help.
 
A

Allen Browne

Did you see the replies to your previous post in:
microsoft.public.access.queries
Subject:
The 'Select' query sometime does not return all the records with .
 

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

problem with 'in' operator, if used with select command 2
The 'Select' query sometime does not return all the records with . 2
The 'Select' query sometime does not return all the records with . 1
problem with 'in' operator, if used with select command 2
Problem with MS Access + Operator in Query 5
LIKE Operator used with a form 3
Passing multiple values using IN operator through parameterized qu 1
Pass Operator to Criteria in Query 2

Top