I have a tblOrders table that has all of the items that have been ordered, the Quantity and Unit Price. In another table, tblPOinfo, that gets the data from the frmPOInput form, I have the Budget Year and the Budget category (I manage 2 different budgets).
I want a report to show me for the selected budget category and budget year each product ordered and the total number of those products ordered and the total spent for that product during the year.
I have tried various queries and have been a total failure. Any help would be greatly appreciated. I am not skilled with Access or programming so I need fairly detailed help.
Thanks to anyone out there willing to help me.