count

[Denys]

I use Access 2000. I have an extensive database of
records for incidents. I have 15 different types of
incidents.

each record has it's unique IDNumber, date, time, etc...
but also has one or more employees attach to it.

I am trying to count the number of incidents, per type,
but I cannot figure it out, since each incident is either
counted 1, 2 or 3 times because of the # of employees
involved in each incident.

I want to report each incident with the employees
involved, but do a count only for incidents.

any ideas would be much appreciated.

thanks
denys

 

[Van T. Dinh]

Do you mean the Incidents Table has a Record for each Incident-Employee
combination, i.e. an Incident may have more than one Record in the Table?

If this is the case, it sounds like you have an incorrect Table Structure.
The Relationship between Incidents and Employees sounds like a Many-to-Many
relationship to me (1 Incident can involved many Employees and 1 Employee
can be involved in Many Incident).

Perhaps, you should post the relevant details of your Table(s) and some
sample data if possible.

Also, don't use your real e-mail address in these newsgroups. You will be
inundated with spams as there are harvesters lurking around.