B
buzzmcduffie
I need to create a rolling 3 month average. I can do this using the following:
Where (((DateDiff("m",[curr_MonthYear],[LoggedMonthYear])) between -2 and 0))
However, I really need the following:
if there are no records for month -1 and/or month -2, go to the last 2
months that have a record.
Any help is appreciated!!
Thanks
Where (((DateDiff("m",[curr_MonthYear],[LoggedMonthYear])) between -2 and 0))
However, I really need the following:
if there are no records for month -1 and/or month -2, go to the last 2
months that have a record.
Any help is appreciated!!
Thanks