merging two files for one mass label set for mailing

[palamino]

Hi there! Thanks for all the useful info one can gain from this forum.
I have a real need to merge two files to obtain on mailing list that I can
print in zipcode order in assending order.
I think one problem is that there are two lists of assigned unique numbers
to each list. When I tried the cut and paste, that didn't work because I
would have had to add about 400 separate lines of data.
I am the membership chair for a non-profit art organization and we are
getting ready to mail out a prospectus. The data bases are 1. nonmember list
for the show (this list is ppl who are not members, but because this show is
"open" it goes out to past members or groups of other art clubs). 2. member
list which has current nonmember (organizations) and member data. This list
has a column that identifies those who get this prospectus as does the other
list. This list is the one from which I would like to make the combined list.
There are the usual name address fields in common that I want to use for this
project.
I need to move quickly on this too. (I did not create nor update information
before this year because I just got voted to the chair position, so I have
some catching up to do with the database in general).
Thanks in advance for any help anyone can give me.
Palamino
Can anyone help with the process?

 

[Jerry Whittle]

Sure. I could already be done if you had provided the exact table and field
names needed.

Basically you need to create two queries each which would pull out the
needed data from each table. Then you would extract the SQL statements for
these two queries then join them together with a UNION statement. Last you
sort these records in the SQL statement OR in a report's Sorting and Grouping
options if you are going to make a report out of it.

Always remember to help us to help you by providing table and field names
plus things like primary and foriegn keys if there's more than one table
involved.

 

[palamino]

I can give you the names of the fields!! but I don't know how to give you the
exact table! One file is named JS_nonmember_list.mdb the other is named BAA
Membership Accounting2.mdb And the field names I need are: first name, middle
name, last name, address, city, state, postal code and mail prospectus. If
you want I can email you the files and talk with you in more detail.
AGAIN, thanks for your help!
Palimino

 

[Jerry Whittle]

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

 

[Jerry Whittle]

Open up both database files. Press the F11 key to bring up the database
window if you can't already see it in each database. Go to Tables on the
Objects bar. Open up the tables until you see those with the data that you
need. Next list the Table names; the database file, and the exact field names
that you need.

Hopefully in one database or the other, you will see a little blue arrow
next to the table icon. This may be a link between the two database files.
See if that is the case. To join together two tables in two different
database files, you need a database link.