J
JennP
Hello -
I have a consumption table set up that records
consumption of a product each week. Then in a query, I
sum the consumption for each month. I need to set up a
query that will show the most recent 12 months of
consumption for a product. For example...
If it is currently March of 2005, the most recent 12
months would be March 2004 through February 2005. This
would provide me with a rolling update with the prior 12
months.
Any suggestions on how I would do this??
Thank you!!
Jenni
I have a consumption table set up that records
consumption of a product each week. Then in a query, I
sum the consumption for each month. I need to set up a
query that will show the most recent 12 months of
consumption for a product. For example...
If it is currently March of 2005, the most recent 12
months would be March 2004 through February 2005. This
would provide me with a rolling update with the prior 12
months.
Any suggestions on how I would do this??
Thank you!!
Jenni