Can I group similar items in a query? Let's say I have a table with 2 columns (Product & Quantity) like this:
Product Qty
Desk-Oak 3
Desk-Maple 6
Desk-Metal 9
Chair-Blue 2
Chair-Red 5
What I need to do is run a query that shows me how many items I have that start with "Desk", regardless of what comes after. Doable?