MS Access Query not filtering the records as per the text provided

[mujju_hayat]

Hi, I am trying to filter the records of a table with a text from one column but its not filtering it. The column that i want to filter is for the text "SAUWH" but it bringing all the other records for the other text which is EGYWH & TURWH etc. I just wanted to filter the column for only SAUWH. Note that the query i have build up is on the live table of the database as i need to filter the query first & then update it.

Please try to give your help here.

Thanks;

 

[bob fitz]

Can you show us the SQL of your query.

 

[mujju_hayat]

here is the sql query,
SELECT SOPHIE_B_COMP_A.C_REFER, SOPHIE_B_COMP_A.MARQUE, SOPHIE_B_COMP_A.N_SERI, SOPHIE_B_COMP_A.C_PRIX_UNI, [INSTRU PL].[Item Number], [INSTRU PL].[TP Saudi USD], SOPHIE_B_COMP_A.C_STOCK_LI
FROM SOPHIE_B_COMP_A INNER JOIN [INSTRU PL] ON SOPHIE_B_COMP_A.C_REFER = [INSTRU PL].[Item Number]
WHERE (((SOPHIE_B_COMP_A.MARQUE)="DATEX-OHMEDA") AND ((SOPHIE_B_COMP_A.C_STOCK_LI)="SAUWH"));

 

[mujju_hayat]

Hi Bob, Any update, hope you have got the query which i have posted. Pls see if you can help me here. the table from which im trying to extract the info is live database table. this query is working fine on the table copied on my system. but giving error when running on the live database table. hope the question is clear to you.
thanks

 

[mujju_hayat]

hi bob, hope you have seen the query which i have posted on the forum.
thanks

 

[bob fitz]

Hi Bob, Any update, hope you have got the query which i have posted. Pls see if you can help me here. the table from which im trying to extract the info is live database table. this query is working fine on the table copied on my system. but giving error when running on the live database table. hope the question is clear to you.
thanks

Is the table "on your system" a table in the the same db as your query or is it in a access db that you link to.
What kind of db is the table in on "the live system". Is this an access db or sql or something else.

 

[mujju_hayat]

Hi Bob, the database is Oracle & i am accessing the table thru access (ODBC).

 

[bob fitz]

I have only ever linked to access db files, so I am unable to offer any advice.