Comparative report while entering new record?
Just wondering if there is a way to show a comparative while entering a new record?
In my case, I have managers entering a productivity report every month with a list of approximately 20 fields where they enter the required numbers. They choose the month and year for the report.
Is it possible on the same record that they are completing, to show a comparative record of last years entries just to the right of the new entries, almost like an inverted portal that would only show one record for the same month but a year previous? Like you would see on most financial statements with the current period and previous period.
Thanks in advance for any suggestions.