I have a table that contains
SCode
FYear
FMonth
Qty
Cost
I need to create a report which will calculate the Year to date information and the Prior year Year to date information and show it along with the current month and the prior year for the current month.
I created individual queries...