Abigail,
Reading your post, I wonder why you have Status in two places and why (as I
believe I asked yesterday) you have the name in two tables in two different
formats.
Is there more information in ITK and Results that is not relevant to the
question? Otherwise, I don't follow the point.
If you are trying to update the Results table Status column with the value
from the ITK table Status column, this is a poor design.
As far as dealing with matching 'AOL IM 6.0' to 'AOL Instant Messenger 6.0'-
no way. Unless you somehow build in the smarts (a look up table maybe to
contain acronym expansions?), Access, SQL Server, Oracle, Sybase, MySQL,
etc.- none of them can possibly determine for you that 'IM' maps to 'Instant
Messenger'. Concatenation simply tacks the pieces of the string together; it
doesn't do anything intelligent.
Sorry that the answer isn't more reassuring.
--
Chaim
abigail22 said:
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
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
:
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?
:
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!!
)