This is how my table looks except I used random numbers for my values. Some of the dx columns have values and some do not. How about actually showing me...

• This reply was modified 8 months, 1 week ago by  genova11.
• This reply was modified 8 months, 1 week ago by  genova11.

Great, thanks for the quick response!!

I am sorry. I am going to move this post to SQL Server 2012. I should not have put it in here.

Thanks. This ended up working for me. I was close. Just had to change the mm to MM because I am on SQL Server 2016.

Between Format(DateAdd(MONTH,-6, GETDATE()), 'yyyyMM') And Format(DateAdd(MONTH,-1,GETDATE()),...

I changed the Column Headings value in the property sheet of the query to this and it worked.  

"201804", "201805", "201806", "201807", "201808"

Thank you. I ended up doing this:
AND (([dbo_RX Reporting].Period)=Format(DateAdd("m", -1, Date()), "yyyymm"))