[mso] Re: Access 97, Query 2 tables ? :VSMail MX1
- From: Jim <n1jmm@xxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 26 Sep 2002 22:31:59 -0400
Thanks James.
Turns out, thats what I had done, I tried it again, still no matches between
the lists, so I dumped them both into a common spreadsheet, sorted and visually
checked them. No dupes between the 2 tables so this was not a good set of
source files for a query
test. I'll try putting some dupes into the tables just to verify the query
works like I meant it to.
Thanks
-Jim-
James LaBorde wrote:
>
> Jim,
>
> What you are referring to is a basic query. Go to the Query tab of the
> Database window and select new. Choose Design View. Next, select the two
> tables you want. To link them select the field(s) that should be the same
> and drag and drop one to the same field in the second table. A single line
> will appear for each one of these connecting the two tables. The default
> setting is to only include records that are the same in each table. This
> means that as long as all the data in both fields match (for all fields you
> link) the item will appear with whatever other data you select. Once you
> have the query selecting everything you want, you can change your query type
> to Make Table instead of Select and create a table of the merged data.
>
> James La Borde
> South Western Federal Credit Union
>
> -----Original Message-----
> From: Jim [mailto:n1jmm@xxxxxxxxxxxx]
> Sent: Thursday, September 26, 2002 2:52 PM
> To: mso
> Subject: [mso] Access 97, Query 2 tables ? :VSMail MX1
>
> 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
> *************************************************************
> *************************************************************
> 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
> *************************************************************
*************************************************************
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
*************************************************************
Other related posts:
