Hi everyone,
Here's the problem I'm facing. I need to get rid of an Excel document and create a table and forms right in Access. This Excel sheet is changed over every month, moving the old months data into another part of the spreadsheet to archive it. I need a way for Access to play the role of this Excel spreadsheet, and auto-archive the data, but in a way that's easy to go back a month. It also needs to bring the last days data over to the current month for it's first day. Also, other forms on this spreadsheet display information from the Excel sheet (currently, it's just a linked database, but they want to abolish Excel completely for this information) and would have to only pull from the current month.
I'm not sure on how I should even really begin with this. Any help would be greatly appreciated, and thanks in advance!
-Walter
Here's the problem I'm facing. I need to get rid of an Excel document and create a table and forms right in Access. This Excel sheet is changed over every month, moving the old months data into another part of the spreadsheet to archive it. I need a way for Access to play the role of this Excel spreadsheet, and auto-archive the data, but in a way that's easy to go back a month. It also needs to bring the last days data over to the current month for it's first day. Also, other forms on this spreadsheet display information from the Excel sheet (currently, it's just a linked database, but they want to abolish Excel completely for this information) and would have to only pull from the current month.
I'm not sure on how I should even really begin with this. Any help would be greatly appreciated, and thanks in advance!
-Walter