Need advice:
Background:
I’m designing a new Access 2013 database. I receive a Spreadsheet report quarterly which I will import into Access. When I receive the second quarters Spreadsheet I want to see what changed from the previous quarter and do some simple addition. In addition, I will need to keep all four quarters for end of year reports.
Problem: I’m perplexed on how to handle the import of each subsequent report. Do I create a new table each quarter? Or do I append to the original? I want to create a form which will contain buttons to run queries. Such as, if field “A “is blank first quarter and again in the second quarter display “ID”.
If I create a new table each time, how can I relate the Form buttons with the newly created table without having to recreate the queries behind the buttons each quarter?
On the other hand, if I have one continues table the field “Computer Name” would be listed up to four times (one for each quarter) with a different ID number. How would I link them back together to validate the differences?
Display Name Publisher Version Install Date Computer Name User Name Adobe Acrobat X Pro Adobe Systems 10.1.16 20151105 APGRNBC3G2J06 Michael.J.Murphy
Thank you for your time.
Dpick