Various entries for 1 day of hrs

[LG]

I have a situation where tables are built and have option of 3 different work
tasks. If the CSR enters say 3 tasks for the day but only has 8 hrs of work
time how do I roll it up on a query/report so that I can get call per hr for
the 1 day.
Ex. Tina works 8 hrs on 5/18 She enteres into the form assigned 100 claims
commericial, 100 claims regualar and 50 Account management. Currently I get
1 line with the correct info and # signs in the other because the other types
of calls don't have sched hrs associated. I would like to roll up all types
into 1 and 1 day of sched hrs?
Please Help

 

[John W. Vinson]

I have a situation where tables are built and have option of 3 different work
tasks. If the CSR enters say 3 tasks for the day but only has 8 hrs of work
time how do I roll it up on a query/report so that I can get call per hr for
the 1 day.
Ex. Tina works 8 hrs on 5/18 She enteres into the form assigned 100 claims
commericial, 100 claims regualar and 50 Account management. Currently I get
1 line with the correct info and # signs in the other because the other types
of calls don't have sched hrs associated. I would like to roll up all types
into 1 and 1 day of sched hrs?
Please Help

Please post a description of your tables. Do you have different FIELDS for
different tasks? If so, that's a mistake: if one day can involve more than one
task, you have a one to many relationship, and should have a second
TasksAccomplished table with fields for the date, the task, and the hours.

 

[LG]

I only have 2 tables. 1 is Employees only with their id number, supervisor,
and dept. The other table is production. This houses type of claim in a
drop down box, scheduled hrs, brks, receive date, completed date, work
assigned.
The problem is I need to pull TAT, claims per hr, and inventory. The other
problem is that I inherited this database and I am fairly new at access.
What other info can I provide for more assistance?

 

[John W. Vinson]

I only have 2 tables. 1 is Employees only with their id number, supervisor,
and dept. The other table is production. This houses type of claim in a
drop down box, scheduled hrs, brks, receive date, completed date, work
assigned.
The problem is I need to pull TAT, claims per hr, and inventory. The other
problem is that I inherited this database and I am fairly new at access.
What other info can I provide for more assistance?

You will need some sort of Totals query on your database. I have *no* idea
what TAT is, or what it is you are inventorying. If you have drop down boxes
("combo box" is the jargon term) in your Table, then you may have more tables
than you are aware of: the Lookup Field wizard creates and conceals tables for
the lookup field values.

Perhaps you could post a description of your production table in the form

Tablename
Fieldname (Data type) (Primary Key)
Fieldname (data type)
Fieldname (data type)

and if the nature of the field's data isn't evident from the fieldname post a
description (and remember that we may not all know what a "claim" or "TAT"
is).