Monthly Consumption Query (1 Viewer)

KINGOFCHAOS17

New member
Local time
Today, 23:42
Joined
Mar 20, 2020
Messages
15
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.
 

Attachments

KINGOFCHAOS17

New member
Local time
Today, 23:42
Joined
Mar 20, 2020
Messages
15
Thank you, but I have no idea how to achieve that. Can you assist me further?
 

arnelgp

error reading drive A:
Local time
Tomorrow, 06:42
Joined
May 7, 2009
Messages
9,286
you can use Crosstab query, if you want.
see Query1.
 

Attachments

KINGOFCHAOS17

New member
Local time
Today, 23:42
Joined
Mar 20, 2020
Messages
15
you can use Crosstab query, if you want.
see Query1.
Thank you, can you explain how/what the queries qryDatesFromMsysObjects and qryNumbersFromMsysObjects are doing? Trying to educate myself here.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom