Hello,
I hope someone can help me in resolving the following in access 2003:
I have a table with the following fields:
emp_id,emp_name,repdate,actions,duration,lob,categ ory,ltstatus
emp_id is not unique and there appears to be no primary key for this table.
the actions field stores the count of all actions recorded under ltstatus and their duration is logged under duration field.
there can be multiple actions for each lob & category.
What i need is the following:
All unique actions need to be sidelined from the table and then for each unique date (repdate), emp_id, lob & category combination, i need the sum of duration and sum of action (the number of actions is currently 8 and hence it makes 8*2=16 fields to record the sum of duration and sum of action for each action)
I am currently able to accomplish the task by looping through the records but it is taking a very very very long time (due to the loops of course)..
What I am looking for is a solution (a query perhaps?) which can do it faster...
Pls help.
Thanks.
I hope someone can help me in resolving the following in access 2003:
I have a table with the following fields:
emp_id,emp_name,repdate,actions,duration,lob,categ ory,ltstatus
emp_id is not unique and there appears to be no primary key for this table.
the actions field stores the count of all actions recorded under ltstatus and their duration is logged under duration field.
there can be multiple actions for each lob & category.
What i need is the following:
All unique actions need to be sidelined from the table and then for each unique date (repdate), emp_id, lob & category combination, i need the sum of duration and sum of action (the number of actions is currently 8 and hence it makes 8*2=16 fields to record the sum of duration and sum of action for each action)
I am currently able to accomplish the task by looping through the records but it is taking a very very very long time (due to the loops of course)..
What I am looking for is a solution (a query perhaps?) which can do it faster...
Pls help.
Thanks.