AnsweredAssumed Answered

Building Reports

Question asked by kdefilip on Mar 25, 2009
Latest reply on Mar 26, 2009 by MikePR_1

Title

Building Reports

Post

I'm new to reports.  I have a task database that has many entries by many of the same people.  For example,

John jones with enter many tasks in a month, all being the same except for date and time.

Bill Adams will do the same

Jenny Jones will do the same

 

At the end of the month, I have to build a report showing each name and their total of tasks entered.  My problem is that because each person has many entries, I don't seem to be able to come up with a list like this:

 

John Jones          312

Bill Adams             15

Jenny Jones        125

 

I don't seem to be able to make the summary part show what I need.  How can I make this happen?

 

DB layout

First_name, Last_Name, Emp_id, Task, Task_date, Task_type (this type is the same type between all persons,i.e. 12)

 

Thanks  for any help you can offer.

Outcomes