Suppressing quotations with the same value
Posted on 2013-02-03
The database I have contains projects. This can be for a building site where materials are supplied and quotations are prepared in this project. Due to the tender or bidding process several quotations may be made in the same project to several different customers. I need to recognise this and only show one quotation per project with the same value. The running total also needs to recognise where a quotation of the same value AND in the same project is present - this value only needs to be included once in the total.
How do I supress the quotations with the same value and in the same project on the reports and how do I ensure the running total also takes this into account