Forum Discussion
From Excel to Access - Match invoices
Hi, I used to use MS Access twenty+ years ago, but lost experience. I'm a heavy MS Excel user nowadays. I do have an issue which I can solve in MS Excel, but don't know how to in MS Access. Is...
Having 4 tables for revenues is not a good idea. It is against the design rule saying that you should store information in field values and not in table or field names. So revenue type should be a field in your single revenue table. I think that will reduce your problem.
Also remember that designing a relational database is very different from building a spreadsheet.
Also remember that designing a relational database is very different from building a spreadsheet.
Thank you for your reply. Make sense, to have all revenue streams in one table instead of four. Yet they are produced this way by different modules in company's ERP. Design of tables is not fully comparable and compatible.
Will try to import the four original tables and combine them in one new one.
