Populating a table

[Guest]

I’m using Access 2003 and I want to create a query that updates fields in a
previously created table. The first column of the table is EMPLOYEE_ID. The
remaining 30 columns are actions that an employee can accomplish such as
APPROVED, DENIED, ABANDONED, RFE. I can create a query that will provide me
with a count by employee of each action but I can’t get that to populate the
table I have already completed. Also, just to complicate things a little bit
more, if the employee hasn’t completed a specific action then a “0†would be
listed in the table.

 

[Steve]

To further complicate things a little bit more .....

Your tables are not correct! You need:
TblEmployee
EmployeeID
....
....
etc

TblAction
ActionID
Action

TblEmployeeAction
EmployeeActionID
EmployeeID
ActionID
ActionDate

Further, if yoyr previously created table records a count by employee of
each action then delete that table. You can always get a count by employee
of each action in a form or report via a Totals query or the DCount
function.


PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

Steve - sorry for not getting back sooner. I should explain that my
knowledge of Access is a bit limited. I guess I should take this a step
further and explain that the reason that I wanted to populate the table with
the counts is that I need to export the table to Excel but I also need to
ensure that each action is counted for each person every time even if the
count is zero. Once it is in in Excel other people do other things with it.
I just need to export the same table every time. The only thing that does
not have to be exact is that if someone was out for the week then their is no
need to count their ID. Is this something I should be looking at from a
different angle?

 

[Steve]

I still have the same response. You can export a Totals query to Excel.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

Thanks - I'll try again and see if I can get it to work.