duplicate values in join query

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

Guest

Hi there,
I'm doing a query on a table which as all the products purchased by a
company. I also need to include the company name and the amount spent on all
the product for that company which are both in a separate table (each product
row has not price, so I can't add them up believe it or not)
When I join the 2 on productIDs I get the total amount spent repeated for
each product for that company.
I go rid of this by putting the amount spent in the header of the company in
the report but when I sum the total for all the companies in the report
footer it still sums the values as if they were repeated for every product.
Any ideas.
Thanks
 
Frank said:
I'm doing a query on a table which as all the products purchased by a
company. I also need to include the company name and the amount spent on all
the product for that company which are both in a separate table (each product
row has not price, so I can't add them up believe it or not)
When I join the 2 on productIDs I get the total amount spent repeated for
each product for that company.
I go rid of this by putting the amount spent in the header of the company in
the report but when I sum the total for all the companies in the report
footer it still sums the values as if they were repeated for every product.
Click to expand...


Add another text box (named txtRunTotal) to the company
header with the same control source as the existing total
text box. Set this new text box's RunningSum property to
Over All.

Now, a text box in the report footer can display the grand
total by using the expression =txtRunTotal
 
Back
Top