wrong results in calculating the sum of some fields in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a problem in calculating the sum of a field in a report, where the
report contains two joined tables because the records of one table are
repeated with every record in the other tableso some fields are added twice
then the sum result is wrong
 
i have a problem in calculating the sum of a field in a report, where the
report contains two joined tables because the records of one table are
repeated with every record in the other tableso some fields are added twice
then the sum result is wrong
Click to expand...

Well? Correct the query so it gives the correct sum.

If you'll post the SQL view of the query and indicate how the sum
*should* be calculated someone should be able to help do so.

John W. Vinson[MVP]
 

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

how do i deal with wrong SUM calculations in a report in access200 1
Want Sum in Report Header of calculated field in Report Detail ? 1
Sum query returns wrong results on a large table 1
sum of calculated fields in header of report 1
Sorting Problem 1
Calculated field in a table 6
How to calculate form field 1
Enter Parameter Value - Custom Calculation In Report 2

Back
Top