Hi all,
I’m new to Access and trying to learn from books.
I got a question regarding how to handle imported tables. The situation is like this, and I'll try to be as precise as I can:
Every month two different Excel sheets should be imported to Access. One lists all employees time in their projects, the other is the corresponding budget for that month. This will give me a lot of tables containing the same kind of information as the months fly by…
In the end I‘d like to compare the employees to the budget, but the time interval should be arbitrary. Hence, information should be gathered from different tables.
How to handle this situation?
I’ve got two solutions in mind, but either way I encounter problems:
1)[FONT="] [/FONT]Work with Queries. The problem here is that I don’t know how to make a query that collects information from two or more tables (with similar kind of content) and show the result in a satisfying way. What I need is a recordset with the records from each table (of similar kind, i.e. tables regarding time or budget) listed one per row.
At this point I’ am able to ask a multi-table query, but the records from each different table are then listed at the same row. Not very handy…
So, how to query the several tables?
2)[FONT="] [/FONT]Merge tables of the same kind, to reduce the amount of similar tables and then just query one table with times and one with budgets.
But how to merge them?
I’m more than a novice regarding programming in other languages than VB, but I can handle the basics though…
Would of course be very grateful if some could help me along with this.
Cheers!
I’m new to Access and trying to learn from books.
I got a question regarding how to handle imported tables. The situation is like this, and I'll try to be as precise as I can:
Every month two different Excel sheets should be imported to Access. One lists all employees time in their projects, the other is the corresponding budget for that month. This will give me a lot of tables containing the same kind of information as the months fly by…
In the end I‘d like to compare the employees to the budget, but the time interval should be arbitrary. Hence, information should be gathered from different tables.
How to handle this situation?
I’ve got two solutions in mind, but either way I encounter problems:
1)[FONT="] [/FONT]Work with Queries. The problem here is that I don’t know how to make a query that collects information from two or more tables (with similar kind of content) and show the result in a satisfying way. What I need is a recordset with the records from each table (of similar kind, i.e. tables regarding time or budget) listed one per row.
At this point I’ am able to ask a multi-table query, but the records from each different table are then listed at the same row. Not very handy…
So, how to query the several tables?
2)[FONT="] [/FONT]Merge tables of the same kind, to reduce the amount of similar tables and then just query one table with times and one with budgets.
But how to merge them?
I’m more than a novice regarding programming in other languages than VB, but I can handle the basics though…
Would of course be very grateful if some could help me along with this.
Cheers!