Good Morning and thank you for previous assistance, I'm fairly new to Microsoft Access and struggling to write a query. I have a simple table containing all issues made to the customer (sample data attached). What I'm trying to achieve is a query which displays the number of times a part is issued over the past 36 month period along with the total consumed for that month. I'm attaching an example that I quickly put together in Excel that I'd like to see. Where zero consumption (issues) occurred in the month I would the field to display a zero (0). Month 1 or M1 in the attached example would only include the last full month. So if I were to run the query today (7 April 2020) then Month 1 would look at anything that occurred in March 2020.
38.1 KB Views: 5
36.4 KB Views: 4