Hi Sean,

Thanks, that helps, but could you complete it?

So let's say you've got a string var 'X' and want to return the function result there. Would this be the code for that?

dim X as String

X = Docmd.RunSQL "select " & dbo.XFunc(@Parm)

Thanks in advance, A.