Query not filter correctly (1 Viewer)

[ielamrani]

Hi,

I am trying to filter this query column (EBL) to give any # greater then 1500 but I am getting all. EBL column in the table is text.

SELECT SAEXPORT.[Patient ID], SAEXPORT.[PT-NAME], [SAEXPORT ADD DATA].EBL, SAEXPORT.[Delivery Maternal Comps v2]
FROM SAEXPORT INNER JOIN [SAEXPORT ADD DATA] ON SAEXPORT.[Patient ID] = [SAEXPORT ADD DATA].[Patient ID]
WHERE ((([SAEXPORT ADD DATA].EBL)>"1500"));


Thank you

 

[jdraw]

Can you show us some sample values of EBL?
I don't see any error with the sql.

 

[ielamrani]

thanks for you quick reply.

the issue is in the table used by the query. EBL column in the table is text column and once I change it to Number it works. the table is imported daily and it change the format to text every time it's imported.

Hope this help

 

[jdraw]

Why do you change it to text? If you are comparing numbers, why not keep numbers?
Can you post a ZIPPED copy of the database?

 

[ielamrani]

I change it to text to see if it make a change and it did. when I keep it as a number the query does not work.

 

[ielamrani]

tried to attach a db but get error.