is this query possible?

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

 

[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

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