Jazeker: My solution to this problem is to write a function ReplNull which returns a default when a value is Null: Public Function ReplNull(ByVal varSource As Variant, _ ByVal varReplaceBy As Variant) As Variant If IsNull(varSource) Then ReplNull = varReplaceBy Else ReplNull = varSource End If End Function Or use the CASE WHEN clause in your SQL statement to replace Nulls by your default. grtz, Guus

:cool: What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.