How do I get a report from various same-type tables, in Access?

A

Aitor

Hi,

I have an Access Database, where every person in the company has one table.
There are like 45 or 50 different guys, and every table has this Info:
- Date of work
- Name
- Total Hours
- Total Deliveries Made
etc...

Now, I want to use this as a payroll and as a tool to measure the
effectiveness of the workers. I can print reports perfectly for just one
guys, but I want a single report that can give me the info, day by day of
every worker.

I having problems, and I don't know how to do it..

please help
 
R

Rick Brandt

Aitor said:
Hi,

I have an Access Database, where every person in the company has one table.
There are like 45 or 50 different guys, and every table has this Info:
- Date of work
- Name
- Total Hours
- Total Deliveries Made
etc...

Now, I want to use this as a payroll and as a tool to measure the
effectiveness of the workers. I can print reports perfectly for just one
guys, but I want a single report that can give me the info, day by day of
every worker.

I having problems, and I don't know how to do it..
Click to expand...

You should not have 45 - 50 tables. You should have ONE table that includes a
field (or fields) to identify the worker.

Any time you have multiple tables with identical structure that is a "big red
flag".
 
J

John Vinson

Hi,

I have an Access Database, where every person in the company has one table.
There are like 45 or 50 different guys, and every table has this Info:
- Date of work
- Name
- Total Hours
- Total Deliveries Made
etc...
Click to expand...

I'm sorry, but this is NOT an appropriate design. It's maybe ok for a
spreadsheet, but this is simply wrong for a relational database.

Instead of fifty tables, you need TWO:

Employees
EmployeeID
LastName
FirstName
<other bio information>

WorkLog
EmployeeID <<< link to Employees
DateOfWork
TotalHours
TotalDeliveriesMade
...
Now, I want to use this as a payroll and as a tool to measure the
effectiveness of the workers. I can print reports perfectly for just one
guys, but I want a single report that can give me the info, day by day of
every worker.

I having problems, and I don't know how to do it..
Click to expand...

A Report based on the table structure above will be very much simpler
to construct. You'll need to run fifty Append queries to migrate the
data from your "spreadsheets" into this table (or, using UNION
queries, maybe five Appends based on five UNION queries, with a little
prep work).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top