Query not filter correctly (1 Viewer)

ielamrani

Registered User.
Local time
Yesterday, 21:37
Joined
May 6, 2008
Messages
51
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

Super Moderator
Staff member
Local time
Yesterday, 21:37
Joined
Jan 23, 2006
Messages
14,430
Can you show us some sample values of EBL?
I don't see any error with the sql.
 

ielamrani

Registered User.
Local time
Yesterday, 21:37
Joined
May 6, 2008
Messages
51
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

Super Moderator
Staff member
Local time
Yesterday, 21:37
Joined
Jan 23, 2006
Messages
14,430
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

Registered User.
Local time
Yesterday, 21:37
Joined
May 6, 2008
Messages
51
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.
 

Users who are viewing this thread

Top Bottom