DATA FROM A SELECTED RANGE COMPARED WITH OLDER DATA

Post Author: NewITGuy

CA Forum: General

Hello , I have a report that I have to write that would Look at all the orders we have placed over the last year by partnumber and compare to see how many times we have purchased that part in the last 3 years. My problem I trying to figure out is that the report range I will need to lock in a record select back to 1 year from now to only show those partnumbers.

If I lock it in that date range how will I be able to compare it to old because they wont show on the report.