469,903 Members | 1,511 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

How to append different tables into one report view (37 tables - different combinations based on search)

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.

- How to append each table records/fields, depending on a selection from a list box, showing it in a report form.

- 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.
4 Weeks Ago #1
0 3969

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Dan Williams | last post: by
4 posts views Thread by Clint Stowers | last post: by
17 posts views Thread by Wilfried | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.