Yep...Access isn't my strong point, like I said...the only reason I even posted my suggestion was cuz Cherie posted her problem twice and I figured no one else was gonna answer. Listen to the Access whizzes, Cherie..not me LOL Linda Linda's Computer Stop http://personal-computer-tutor.com ABC Free Ezine ~ Free Ebooks and Tutorials *all outgoing mail scanned by Norton AV. If you got a bug that looks like it came from me, it did NOT! -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of James LaBorde Sent: Tuesday, June 01, 2004 2:32 PM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: E-mail merge using Access and Word :VSMail mx5 Cherie, I didn't see your stated desire to keep a single record per student in the database. (This would be where relational of relational database can help you but we will get around that). While the MakeTable/Append Table option will work, it will also lead to database bloat. With the size of your database already up there, you will want to avoid that. Two recommendations here. First, make sure you compact your database regularly and keep a good backup copy at all times. Second, consider using a Union Query. A union query simply takes two queries and combines them into one. Here is what you will want to do: ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************