I'm in need of your help again.
I have a data table with PartId, RentalDate, RentalCost
I need to sum in various ways based on the rental date. I.E.
Get total sums for each PartId rented in October
AAD11 £ 302.00
BAR233 £ 626.00
CDN112 £ 104.45
Get total sums for each PartId rented in 2015
AAD11 £ 15,122.00
BAR233 £ 19,728.00
CDN112 £ 10,460.15
Get total sums for each month of 2015
January £ 901.26
February £ 678.80
March £ 877.10
How would I go about that?
Sorry if it's too much to ask.
Thanks for your help.