I'm looking to make an access report that is dependent on data from a remote SQL Server. Additionally, I want to run some additional queries off of that data that is returned from the SQL Server.

Use SQL to quickly create a new table from existing records in Access Your email has been sent SQL lets you use one command to quickly create a new table containing a subset of records from a ...