Access uses wizards to simplify the process of creating reports or queries that select and retrieve information from your databases. Queries are instructions to the database that ask for information.

Processing is carried out by SQL Server on the database server, not in Access on the client side. As a result, you’ll see a reduction in network traffic (as opposed to a split MDB).

Take that recordset and use it to create a new table (a temporary one) in the local Access database.<BR>3. Close the recordset.<BR>4. Run my report off the new temporary table<BR>5.

Elaine Kelly – “I attended the SQL training course in London to try and streamline our current inhouse MS Access database. It is full of duplicate and inconsistent data.