Re: Holding Lists--Merging (Shawn King)
Marcia Tuttle 06 Oct 1998 23:38 UTC
---------- Forwarded message ----------
Date: Tue, 6 Oct 1998 16:34:44 -0500
From: Shawn King <srking@NOCTRL.EDU>
Subject: Re: Holding Lists--Merging (Charles Dabkowski)
I have had success in doing a similar list merging in Access. I created
tables for each individual list, then merged them in 2 different ways
(1) creating a query that makes a "new" table and adding successive
tables to the "new" master table in append queries or (2) creating a
query that incorporates all table lists holding information and
manipulating the results in a report.
Let me know if you need any detailed information or samples of queries.
Shawn King
--
-----------------------------------------------------------------------------
Shawn King North Central College
Acquisitions & Serials Librarian Oesterle Library
srking@noctrl.edu 320 E. School Avenue
(630)637-5712 Naperville, IL 60540
-----------------------------------------------------------------------------