Total is not calculating correctly

[Guest]

Here is the setup:

In ClassID header I have: ClassDate, ClassName, CompetencieID, Credithours
In the detail I have:Competency name(each class could have multiple
competencies)

For my report total: If a class had 2 credit hours but 3 competencies in
the detail the Total Credit hours is reporting 6 instead of 2. The way I
have the calculation in the report total is =sum([credithours])

Any advice would help

JZ

 

[Larry Linson]

If the CreditHours applies just to Class -- and shouldn't be counted/summed
for each Competencie, don't use the Sum function. That's what seems to be
the case here.

Larry Linson
Microsoft Access MVP