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.

The INTO clause behaves the same as CREATE TABLE in other SQL environments. SELECT * INTO new_table FROM old_table WHERE last_name LIKE 'Ja%'; GO The LIKE keyword allows you to filter results ...