Filter for Last 3 Days in Each Month

[Littlemalky]

Hi, I'm trying to build a query against a daily sales table that returns the sales for the last three days in each month for this year. I'm not sure how to create the function to limit just the last three days in each month. My purpose is to try to calculate the average daily sales in the last three days of the month to help us forecast where we will land.

Essentially, I want my results to show these columns: Date, Month, Sales.

example:

1/29/2016 | 1 | 50,000
1/30/2016 | 1 | 35,000
1/31/2016 | 1 | 42,000
2/27/2016 | 2 | 30,000
2/28/2016 | 2 | 15,000
2/29/2016 | 2 | 12,000
etc.

 

[Joe4]

Add this Criteria under your Date field (assuming Date field is named "MyDate" - change it to match your date field name):

DateSerial(Year([MyDate]),Month([MyDate])+1,1)-[MyDate]<=3