Query results in double totals

R

Rohricht

I created a query using totals from two other queries. I grouped by student
id, but the sum of the total is duplicated. Do you have any idea what I
could be doing wrong?
 
J

Jackie L

It would depend on the detail you are using before your grouping. If you
take the grouping off, do you see two records for each student? Perhaps on
that field you would need Max, First or Group by instead of Sum.

Hope this helps.
Jackie
 
Top