problem with 'in' operator in select query

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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 .
 
Back
Top