Counting Fields In A Report 1

[Jengo]

I have a table that has information about training issues in our company. It has the name of the person, issue, and the date. I want to be able to run a report that will give me the issue and the number of times it came up. Can anyone help me? I will try to show you an example below of what I want.


Reason: Number of Times
"Stupid Employee" 10
"Good Employee" 3

 

[JoaoTL]

Sorry,

*will give me the issue and the number of times it came up*

Came up What, The issue, the report?? -------------------------
Regards
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt/Access

-------------------------

 

[JoaoTL]

Ok, i think i get it. Assuming that you want to count the Number of related issues to a Person try this Query and insert a SubReport with this 2 Fields.

SELECT YourTable.NameOfPerson, Count(Table.Issue) AS CountOfIssue
FROM YourTable
GROUP BY YourTable.NameOfPerson;

Hope it helps

-------------------------
Regards
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt/Access

-------------------------

 

[JoaoTL]

UPPPSSS, Sorry

SELECT YourTable.Issue, Count(YourTable.Issue) AS CountOfIssue
FROM YourTable
GROUP BY YourTable.Issue;

-------------------------
Regards
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt/Access

-------------------------

 

[Jengo]

where do i put that code?

 

[Jengo]

Oh, I am sorry, duh I know it goes in a query. Thanx alot it worked great. That is exactly what I wanted.