The last thing I want to do for the DB I'm making is create a report that shows me the products, quantity of each product, and cost of materials I used through the whole year. I attached the query view with the tables I'm using. To calculate the year, I figured I could sort the aggregate query with the DateCompleted field, but instead it just separated the products. The workorderT contains the materialT which gets the data from the productT. I've tried every combination of things I could think of to get the right data to show up and I really just want to bang my head on my desk. I really appreciate any help.