Best way to show data from previous month
I'm working on a DB that holds statistical information entered on a monthly basis. One requirement they have is to be able to view the entries from the previous month on the screen where they enter data for the current month.
Since there are multiple locations it wouldn't be as easy as just going back one record. I'd have to have the script find the correct past record based on location and date.
Would I need to create new fields for the "previous entries"?