counting number of events

Hi,

I have the following problem.

I am making a report where i want to display various agent events stored in the database.

so i have a table with my agents and a table with possible events + event description.

how can i display the total of certain events

for example : for agent1 from date1 till date2 i want to see (count) all events=2 (EventID=2).

So i want the see the number of occurrences

Vincent

[463 byte] By [VSempoux] at [2008-1-2]