If field is null or empty

[dinster]

Hi i have this code which checks for carriage returns ms access 2003 query....

EXAM_Neuro1: Replace([EXAM_Neuro],Chr(10),Chr(13) & Chr(10),1,-1,1)

I get an error msg on the field if its null...how do i take that in to consideration?

Many thanks

 

[JerryKlmns]

SELECT Replace([EXAM_Neuro],Chr(10),Chr(13) & Chr(10),1,-1,1)
FROM YourTableName
WHERE EXAM_Neuro Is Not Null

 

[JerryKlmns]

And if you care also about empty

SELECT Replace([EXAM_Neuro],Chr(10),Chr(13) & Chr(10),1,-1,1)
FROM YourTableName
WHERE EXAM_Neuro & "" <> ""