Looking for a way to calculate a three month average with three criterias (Transaction date, Area and product id).
Current code is:
a ='" & [Area] & "' AND Month(format(TransactionDa
yyyy') <" & (Month(Format([Transaction
Struggeling with the Transaction date as I only receive an error in the query (the data is only monthly and all data is therefor set to 1/1/2015 for Jan and 2/1/2015 for feb).
I would also need product ID to be part of the criteria for the three month moving average.
Any suggestions? I've attached the test database as well.