Hi everyone, I am currently working on an MS ACCESS database for one of our departments.
I am currently stuck, wondering how I can make it less tedious and won't make the application crash due to heavy data in it.
The reason why I had to do it on ACCESS is because right now, there are three different EXCEL worksheets that 2 different groups of people work on, just to be combined into one main report by the group leader. So I figured having it all in one MS ACCESS database, allowing data entry by techs, and then updated by Senior Supervisor, and then report generated by the group leader, all in one file, will make back and forth out of the equation. Thus, efficient. I am planning to split the database after figuring out what to do with the reporting to make it lighter for everyone working on it.
Issue:
- How to append each table records/fields, depending on a selection from a list box, showing it in a report form.
Background:
- I created 37 tables (for different sample data - input on a daily basis).
- Each 37 tables has the following fields: [SAMPLE DATE] | [TAMS] | [TATS] | [TPC] | [MODIFIED ON]
- Has a Form for data entry for techs, that sends the data on SQL UPDATE to the corresponding table.
- **TRYING to create a form that is technically for search purposes, where they can select which samples they want to view, which tests they want to see (specifically), and which date range (Date Range option is easy).
- I already have a main report done and fixed for everything - it wasn't much work since it fixed and everything is there already.