As I understand, within SQL Server a stored procedure can be written to provide a recordset as though it was an actual table or view. Is there anything in Access 2010 that would allow the same functionality? I know I could do it in SQL Server, then link Access to that SQL Server view, but I need to keep this in Access.
If this functionality is not available in Access, I plan to build a temp table with records generated from a function and added to the temp table.