D
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
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