Collecting records from different tables

[danfryp]

I'm very new to access and have been trying to teach myself using the help
facility, but I'm now stuck and could use some advice.

I am creating a database of employee timesheets. I receive 20 excel
timesheets per month. Each of these timesheets has the number of hours and
the clients that these employees worked for. I have linked to 20 sets of
data in and used a append query to add this into a seperate table for each
employee.

What I would like is enable access to search the 20 tables and select
records for a particular client and then combine these into a seperate table
automatically.

I thought I could do this by using a seperate query for each Client (at
present a total of 40) and then telling the query to search each employee for
this client and combinet the records.

This I'm guessing would be an arduous and prolonged process. Am I heading
the wrong way with this. Any advice would be very welcome.

Thanks

 

[Duane Hookom]

I would append the data from the Excel sheets into a single table. Having
multiple employee tables is not a good solution.

 

[danfryp]

Many thanks Duane. Problems solved.

I would append the data from the Excel sheets into a single table. Having
multiple employee tables is not a good solution.