Excel doesn't recognize the nz function used in Access queries. I can have a query that runs fine in Access (using the nz function) but when opened from Excel it's not recognized. Is there a reference I can add to make these work, or do I have to rewrite all my sql using an if isnull call instead.

nz(x.FieldName,0) is cleaner than if(isnull(x.FieldName),0,x.FieldName)

Thanks,

Brian

Brian,

I suggest you write a 'User Defined Function' (UDF).

Function nz(myContent As Variant)
    If IsNull(myContent) Then nz = 0 Else nz = myContent
End Function

then whenever you reference a cell using the =nz(a1) format the cell A1 is evaluated by the function and a result of a number or a letter will be returned.
If, as it appears to be, you are using coded SQL, why not have the conversion routine done at the SQL end so that every record is populated with a real character albeit a blank rather than null.

Cheers

Matthew