Query results in double totals

G

Guest

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top