I'm looking to make an access report that ... data that is returned from the SQL Server. I have concluded that the easiest way may be to create a temporary table that I can generate the report ...

I did not write the app and access would not have been my choice for a data store since we have full blown Oracle and SQL Server ... still need to link his app to the DSN that I created.