Project: build the weekly reorder list (cafe)
List the items below their reorder level with how many to order and the supplier's email, sorted for the buyer.
- Level
- intermediate
- Time
- ~14 min
- Task
- Build the query
- Access
- Pro
Checking your access…
About this exercise
What you'll practise
Combine filtering, a calculated column, a lookup merge and a multi-key sort into a usable report.
The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.
Input
- Stock (table)
- SKU: text
- Item: text
- Warehouse: text
- OnHand: number
- ReorderLevel: number
- Supplier: text
- UnitCost: number
- Suppliers (table)
- Supplier: text
- Email: text
Expected output columns
Supplier (text), Email (text), SKU (text), Item (text), Order Qty (number)