query with Oracle table attached via ODBC

[Jim Jacoby]

I have an Oracle table attached via ODBC. I run a query
against the table trying to get records with a Status code
of "CANCELLED". When I run the query, I get records that
have "CANCELLED" but I also get records that
have "CLOSED", "SENT", or "PROCESSED" in the Status field.
I have even pared down the query to have only one table
with one field in the grid. ANy help would be appreciated.

 

[John Viescas]

Please post the SQL from your query.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)

 

[Jim Jacoby]

Hi John,
Thanks for taking the time to respond. I tried this in
both A97 and A2K.

SELECT DTSUSER_REQUEST_DETAILS.REQUEST_STATUS_CDE
FROM DTSUSER_REQUEST_DETAILS
WHERE (((DTSUSER_REQUEST_DETAILS.REQUEST_STATUS_CDE)
="CANCELLED"));