I'm coming from a MS-SQL Server background, and I'm accustomed to
writing stored procedures that mix programming logic and SELECT
statements to create a final recordset which is the return value of
the stored procedure. I often write queries that JOIN against the
stored procedure name, as if the stored procedure were a table.

Is there anyway to simulate this same thing in Access 2003? Can a VBA
function return a DAO Recordset and can my Access query then refer to
that VBA function by name in a JOIN?

Thanks,

Allen