I'm looking to make an access report that is dependent on data from a remote SQL Server ... Take that recordset and use it to create a new table (a temporary one) in the local Access database.< ...

I tried this in the past, but didn't have any luck.<BR><BR>Is it possible to create a temp table on a remote server?<BR><BR>Situation:<BR><BR>I have to run a group of queries against a remote server.< ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION ... The result is a temporary table that contains values from two tables, where the record satisfies the WHERE ...