That isn't what Laurie meant. She really was asking if you could post the actual definitions, not just some names that don't help us much.

My question is, what have you tried? Aside from being hideous from a formatting and readability perspective (Access creates horrible formatting) this should work unchanged.

I would make a couple of suggestions though. I would change the table names and get rid of the spaces, that just makes queries a LOT more difficult to write and read. The second suggestion would be to use aliases (this is not something Access does).

Here is your query after running it through a formatter.

SELECT DISTINCT [IDEA Attribute Templates Distinct].Segment

, [IDEA Attribute Templates Distinct].Family

, [IDEA Attribute Templates Distinct].Class

, [IDEA Attribute Templates Distinct].Category

, [IDEA NSIIndustriesInc10875117 AM].UNSPSC

, [PPO All Suppliers with IDEA Seller ID].[PPO All Suppliers].Supplier

, [PPO All Suppliers with IDEA Seller ID].[ITEM PART #]

, [PPO All Suppliers with IDEA Seller ID].DESCRIPTION

FROM ([PPO All Suppliers with IDEA Seller ID]

LEFT JOIN [IDEA NSIIndustriesInc10875117 AM]

ON ( [PPO All Suppliers with IDEA Seller ID].[ITEM PART #] = [IDEA NSIIndustriesInc10875117 AM].[Catalog Number] )

AND ( [PPO All Suppliers with IDEA Seller ID].[IDW Seller ID] = [IDEA NSIIndustriesInc10875117 AM].[Seller ID] ))

LEFT JOIN [IDEA Attribute Templates Distinct]

ON [IDEA NSIIndustriesInc10875117 AM].UNSPSC = [IDEA Attribute Templates Distinct].UNSPSC

WHERE (( ( [PPO All Suppliers with IDEA Seller ID].[Target Suppliers v2].Supplier ) = "NSI" ))

ORDER BY [IDEA Attribute Templates Distinct].Segment

, [IDEA Attribute Templates Distinct].Family

, [IDEA Attribute Templates Distinct].Class

, [IDEA Attribute Templates Distinct].Category

, [IDEA NSIIndustriesInc10875117 AM].UNSPSC

, [PPO All Suppliers with IDEA Seller ID].[PPO All Suppliers].Supplier

, [PPO All Suppliers with IDEA Seller ID].[ITEM PART #];

This is better but still pretty awful. All the spaces in your column and table names makes this just incredibly difficult to decipher.