Relationships link one Table to another. This article explains how to Create, Edit and Delete a Table Relationship in Microsoft Access.

Access will display a blank Table window in ‘ Design ’ view. In the new table, for the first field, enter a field name and a data type. Read: How to Create, Edit and Delete a Table ...

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.