See
Re: SQL return assignment Thread #
746712 Message #
746751>How can I run a SELECT sql statement and assign the return to a variable? It's only ever going to return one value
>
>ie:
>cName = SELECT source_name FROM tblThisTable WHERE Uid = 1001
>
>Except that doesn't work.
>
>Thanks!
--sb--