I'm pretty adept with excel but am still a beginner with access.
I have 2 tables:
1. All Data table that houses all the raw data for the products in the database organized by fields like Sku, vendor, part number, noun, type, trademark, comp, etc.
2. Order table that houses the order of the...