Creating Queries to Merge Source Tables
The qryMergeCensusTables query merges two source tables named tblDts and tblFixInformation. If the source tables you want to merge have different names, you need to create a new query based on qryMergeCensusTables.
To create a new query for merging source tables:
1 Exit HelpDesk Admin and open Program Files\Vector\HelpDeskTools\Admin.mdb in Microsoft Access.
2 In the Objects list, click Queries. Click qryMergeCensusTables and click Design.
3 In the View menu, click SQL View.
4 In the SQL statements, replace all occurrences of tblDts and tblFixInformation with the names of the source tables you want to merge.
5 In the File menu, click Save As and type a name for the new query.
6 Close Admin.mdb.
7 Open Program Files\Vector\HelpDeskTools\Admin.mde.
8 Open the table tblImport and add a new record. In the tName column, type the name of the query. In the nID column, type a unique, numeric ID for the query (use the next available nID).
9 Close Admin.mde.
The new query is now available in the Source Table list of the Import Issues dialog.
Related Topics
Importing Issues into a Source Table
Combining Multiple Source Tables