G
Guest
Is there any way where I can query Adobe Acrobat 6.x from ITK showing if the
object is Approved/Non-Approved and also take the Adobe Acrobat 6.x from
Results so that I will be able to "match" Adobe Acrobat 6.x from ITK and
Results and "merge" its Approved/Non-Approved status?
ITK Table:
Vendor Product Version Status
Adobe Acrobat 6.x Approved
Microsoft Word 2000 Approved
AOL Instant Messenger 6.0 Non-Approved
Results Table:
Product Status
Adobe Acrobat 6.x (blank)
Microsoft Word 2000 (blank)
AOL IM 6.0 (blank)
There are also instances where the ITK Vendor/Product/Version doesn't
exactly match the Product name on the Results table (even with the
concatenation, see AOL IM vs. AOL Instant Messenger). Is there any way I
would be able to "merge" these 2 tables without manually going through each
one and renaming? (There are close to 20,000 objects in Results).
-Abigail
object is Approved/Non-Approved and also take the Adobe Acrobat 6.x from
Results so that I will be able to "match" Adobe Acrobat 6.x from ITK and
Results and "merge" its Approved/Non-Approved status?
ITK Table:
Vendor Product Version Status
Adobe Acrobat 6.x Approved
Microsoft Word 2000 Approved
AOL Instant Messenger 6.0 Non-Approved
Results Table:
Product Status
Adobe Acrobat 6.x (blank)
Microsoft Word 2000 (blank)
AOL IM 6.0 (blank)
There are also instances where the ITK Vendor/Product/Version doesn't
exactly match the Product name on the Results table (even with the
concatenation, see AOL IM vs. AOL Instant Messenger). Is there any way I
would be able to "merge" these 2 tables without manually going through each
one and renaming? (There are close to 20,000 objects in Results).
-Abigail
Chaim said:You should be able to query with a criteria like:
ITK.Vendor & " " & ITK.Product & " " & ITK.Version = Results.[Whole Product
Name]
(All on one line in the Query grid if your reader splits that line)
This will work provided that the concatenated string (including space,
punctuation, case) match exactly.
Good Luck!
--
Chaim
abigail22 said:Chaim --
Thank you for your reply! The ITK table has information about the objects if
they are Approved or Non-approved. I am trying to merge that information with
the Results table. Once I do the concatenation, do you think it would be
possible to do this?
Chaim said:If I understand correctly, the ITK table contains the product name as three
columns:
Adobe, Acrobat, 6.x- presumably all as text fields. You can use the
concatenation operator to merge them into a single value:
select Vendor & " " & Product & " " & Version as [Product Name] from ITK;
But I am not sure what "query these two together" means. Are you trying to
fiind products missing from one table that are present in the other? Are you
trying to put together a comprehensive list of all products? For that matter,
why do you have the same data in different formats in different tables?
I think you have to let us know where you're going.
--
Chaim
:
I have 2 Tables: ITK and Results
I have objects in ITK such as: Adobe Acrobat 6.x, Microsoft Office 2000.
These Product names are split into 3 columns: Vendor, Product, Version
I have similar objects in Results, but the whole Product name is in ONE
column.
Is there any way I would be able to query these two together? How would I go
about doing so? Would I need to manipulate the text? I don't know much about
Access. Any help would be much appreciated!!