Counting the number of events a person attended

F

Fiachra

Hi

Iam trying to do an update query
I have two tables
Emplyee with fields
-Inumber
-Name
-NumberEvents

Events
-EventID
-Inumber

I want the query to be able to go through the events table and count how
many events each employee has been to and update the NumberEvents field in
employee
I have been trying to this for ages and amnot sure it is even possible any
ideas would be appreciated.

Thanks
 
T

taps54

In your query design select the totals tool (Epsilon) and you can select
count from the dropdown.
 
J

John Spencer

It is possible to do. BUT it shouldn't be done. You should always use a
query to get the information so it is always correct based on the events the
employee attended.

SELECT Employee.INumber, Employee.Name, Count(EventID)
FROM Employees LEFT JOIN Events
ON Employees.INumber = Events.INumber
GROUP BY Employee.INumber, Employee.Name
 
F

Fiachra

yeah that worked John, thanks for your help

John Spencer said:
It is possible to do. BUT it shouldn't be done. You should always use a
query to get the information so it is always correct based on the events the
employee attended.

SELECT Employee.INumber, Employee.Name, Count(EventID)
FROM Employees LEFT JOIN Events
ON Employees.INumber = Events.INumber
GROUP BY Employee.INumber, Employee.Name
Click to expand...
 
Top