how to view data?

I need to combine some data from three tables and do a calculation in the process. I have a form in my .adp file with a button that executes the query. The user selects values from four combo boxes and then clicks the "execute" button. They should be presented with a table (view?) containing records that match the criteria selected in the four combo boxes. One of the combo boxes specifies a field to include in the results rather then just a value from a field. I have this working fine in Access using VBA to build a make-table SQL statement. A table is created (or deleted and recreated) and the user sees the results of the query.

In SQL Server, it does not seem so simple. Should I use a "view"? Or maybe a "stored procedure"?

Thanks,
Doug = [SQLServerNewBee].[Members]