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
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