Prior YTD

[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 prior year on the same report?

 

[Newman]

Use two subreports, each with it's own query.

 

[jollofrice]

You can also just add the query information or calculation to the report record source and then drag a new control to the form from the Field List.