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.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

You must first create a new database, then create the tables that store the website information. Access is beneficial for small websites and webmasters who are unfamiliar with database structures.

Learn how to build tables with the Table Designer in Access. The process will help you analyze large amounts of information, and manage data efficiently.

I'm trying to create a linked table in Access from an Outlook shared contact list folder. This is easy to do with my own contact list because there is a wizard that can do it for you.