Wrong totals in report

J

jerry

I built a report based upon a query that joins two tables: 1) has vendor name
and the total spent on that vendor, and 2)has contract details. My problem:
when there are multiple contracts with a single vendor, the vendor name and
the amount spent prints for each contract, thus throwing off the totals for
each contract class. How can I fix this?
 
K

KARL DEWEY

Your problem is that you are storing calculated data -- "total spent on that
vendor"
Store each contract cost with the contract information and not store total
any place. Calculate it when you need it.
 

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

Top