[mso] Access 97, Query 2 tables ?

From: Jim <n1jmm@xxxxxxxxxxxx>
To: mso <mso@xxxxxxxxxxxxx>
Date: Thu, 26 Sep 2002 17:51:35 -0400

Lets see if I can correctly explain what I want to accomplish.

I have 2 spreadsheets of inventory data that I have imported into a new 
database as 2 seperate tables.

Each table now has fields containing 'partnumber' and 'serialnumber' along with 
various other fields.

What I want to do is compare the 2 tables, possibly generate a new combined 
table, or at least a report that shows ONLY the partnumbers and serialnumbers 
that are in both table, note each table contains other fields that I want to 
carry over into the new
table or report. Entries that ARE NOT in both tables should be ignored.

I've tried to build a quiry for this, but I havn't had any positive results 
yet. Unfortunately the class I just attended Tuesday didn't deal with multiple 
tables and the instructor refused to answer my questions except to say that 
would be covered in a
higher level class which isn't available until mid next month.

Any help is Greatly appreciated.

Thanks

-Jim-

*************************************************************
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?Subject=unsubscribe

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

[mso] Access 97, Query 2 tables ?

Other related posts: