Query/report problem

L

lou

I am trying to do a summary report showing info on employees, such as full
name, jobs and courses. Some employees may have had more than one job at the
company, and obviously some will have completed more than one training
course. I am completely struggling on how to show jobs and courses as a
numerical value, rather than list the details.

Any help would be GREATLY appreciated!
 
R

Rick B

Unless you share the structure of your database (tables and fields) it would
be almost impossible for us to answer this question.

Rick B
 
L

lou

Sorry, I'm pretty basic at this!

I have a query that gives the following information
full name
department
course

when I run my query it gives:
john smith
finance
first aid

If John Smith has done two courses it will bring up his department details
again and the course, therefore I get the same department twice.

I want it to look kinda like:
John Smith Jobs: 1 Courses: 2

I don't know how to get it to count up the number of jobs and courses, I've
tried =count[department] and =count[course] but as I said, it is telling me
this:

John Smith Jobs: 2 Courses: 2

Sorry I can't be more specific but I'm useless!! Also not good at SQL, so
any way I can write this info into my report, or query would be best.
 
Top