quering multiple values

[ciarra41]

I'm trying to pull data using multiple criteria. But when there's more that one value it's only pulling the first or sometime nothing.
These values are text, something like 011422,142457,154774

I've tried:
=”011422”,”142457”,”154774”, : nothing
,
In(011422,142457,154774) only the first comes back

“And” only returns the first.

The data being queried in Access but I have ODBC connecting to an Oracle table.

 

[PHV]

And this ?
IN ('011422','142457','154774')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ciarra41]

Now I'm getting a data type mismatch