I am not an Access person, but Access absolutely can call stored procedures within SQL Server and based on what you're describing, that's what you want, not a view. Or, you could try putting this into an inline table valued function. That can be called more or less just like a view. Just don't create a multi-statement table valued function. They generally perform very poorly.