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 ...

Use SQL to quickly ... Follow these steps: Access will insert all employees’ records from the Fort Myers office into the new table called Phonelist. Check out the Microsoft Access archive ...

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.