Recent content by bepi1

I have a table that contains 24 months of sales information by product. The fiields are Product, Invoice Date, Amount. I need to create a report that has the columns Current YTD Amount and Prior YTD Amount. I can create a query for the current ytd but how do I get the same period for the...