Good Day,
I am very much a rookie when it comes to access, and I am trying to use it for analysis that I feel is far beyond excel, and I am not ready for SQL.
I have attached the excel file of data, as the Access file would not load.
What I would like to do, is get a list of of orders where the INV_ITEM_CAT is Labor and SOURCE - PROPRIETARY, ONLY on that order. The order numbers can be found in the first column "ORDER-NUMBER".
When I do a query I would like to find the orders that only have LABOR & SOURCE - PROPRIETARY on them, no speakers or amplifiers or anything else. This way I can pull in the rest of the data and analyze.
I hope this makes sense, and I thank you sincerely for any help given.!