I have two tables- one is a master file, the other is a list of exclusions (Category Exclusions). I need to exclude the Category Exclusion values from the Master File. I did a table join and found some feed back on this site on how to exclude those values, when I integrate the change as noted on this site, I keep getting a separate window that pops up asking me to input the value for my Category Table. I just want to see a report with the items excluded. I've attached my SQL code. Please help if you can.
SELECT [T_2007 WW Spend_Master File - Final].GOC, [T_2007 WW Spend_Master File - Final].MRC, [T_2007 WW Spend_Master File - Final].[MRC Name], [T_2007 WW Spend_Master File - Final].Region, [T_2007 WW Spend_Master File - Final].Country, [T_2007 WW Spend_Master File - Final].[Supplier Number], [T_2007 WW Spend_Master File - Final].[Supplier Name], [T_2007 WW Spend_Master File - Final].[Category Code], [T_2007 WW Spend_Master File - Final].Category, [T_2007 WW Spend_Master File - Final].[Sub-Category Code], [T_2007 WW Spend_Master File - Final].[Sub-Category], [T_2007 WW Spend_Master File - Final].UNSPSC, [T_2007 WW Spend_Master File - Final].[Commodity Desc], [T_2007 WW Spend_Master File - Final].[Default UNSPSC], [T_2007 WW Spend_Master File - Final].[Minority Owned Code], [T_2007 WW Spend_Master File - Final].[Minority Owned Description], [T_2007 WW Spend_Master File - Final].[Womend Owned Code], [T_2007 WW Spend_Master File - Final].[Veteran Owned Code], [T_2007 WW Spend_Master File - Final].[Veteran Owned Decription], [T_2007 WW Spend_Master File - Final].[Hub Zone Code], [T_2007 WW Spend_Master File - Final].[Hub Zone Description], [T_2007 WW Spend_Master File - Final].[Business Size], [T_2007 WW Spend_Master File - Final].[2007 Spend], [T_2007 WW Spend_Master File - Final].Currency, [T_2007 WW Spend_Master File - Final].[Spend Type]
FROM [Category Exclusions] LEFT JOIN [T_2007 WW Spend_Master File - Final] ON [Category Exclusions].UNSPSC_DISPLY_NM = [T_2007 WW Spend_Master File - Final].[Commodity Desc]
WHERE ([Category Exclusions]) Is Null
GROUP BY [T_2007 WW Spend_Master File - Final].GOC, [T_2007 WW Spend_Master File - Final].MRC, [T_2007 WW Spend_Master File - Final].[MRC Name], [T_2007 WW Spend_Master File - Final].Region, [T_2007 WW Spend_Master File - Final].Country, [T_2007 WW Spend_Master File - Final].[Supplier Number], [T_2007 WW Spend_Master File - Final].[Supplier Name], [T_2007 WW Spend_Master File - Final].[Category Code], [T_2007 WW Spend_Master File - Final].Category, [T_2007 WW Spend_Master File - Final].[Sub-Category Code], [T_2007 WW Spend_Master File - Final].[Sub-Category], [T_2007 WW Spend_Master File - Final].UNSPSC, [T_2007 WW Spend_Master File - Final].[Commodity Desc], [T_2007 WW Spend_Master File - Final].[Default UNSPSC], [T_2007 WW Spend_Master File - Final].[Minority Owned Code], [T_2007 WW Spend_Master File - Final].[Minority Owned Description], [T_2007 WW Spend_Master File - Final].[Womend Owned Code], [T_2007 WW Spend_Master File - Final].[Veteran Owned Code], [T_2007 WW Spend_Master File - Final].[Veteran Owned Decription], [T_2007 WW Spend_Master File - Final].[Hub Zone Code], [T_2007 WW Spend_Master File - Final].[Hub Zone Description], [T_2007 WW Spend_Master File - Final].[Business Size], [T_2007 WW Spend_Master File - Final].[2007 Spend], [T_2007 WW Spend_Master File - Final].Currency, [T_2007 WW Spend_Master File - Final].[Spend Type]
HAVING ((([T_2007 WW Spend_Master File - Final].Region)="NA")); |