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?
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?