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.
I had a sales database (daily food and beverage sales). My layout was to enter lunch sales on Tab1, dinner sales on Tab2, settlements on Tab3, and flipping to Tab4 was the comparative sales for last week, last month, and last year.
I had a self-relationship with dates so it showed the lookups from the indicated periods.