Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

merging two files for one mass label set for mailing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
palamino - 17 May 2007 18:02 GMT
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 - 17 May 2007 19:34 GMT
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.
Signature

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

> 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
[quoted text clipped - 17 lines]
> Palamino
> Can anyone help with the process?
palamino - 17 May 2007 21:59 GMT
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

> Sure. I could already be done if you had provided the exact table and field
> names needed.
[quoted text clipped - 30 lines]
> > Palamino
> > Can anyone help with the process?
Jerry Whittle - 18 May 2007 15:24 GMT
Signature

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

> 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
[quoted text clipped - 38 lines]
> > > Palamino
> > > Can anyone help with the process?
Jerry Whittle - 18 May 2007 15:24 GMT
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.
Signature

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

> 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
[quoted text clipped - 38 lines]
> > > Palamino
> > > Can anyone help with the process?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.