This leaves the question of which SUM you want, unanswered. Clearly, the supplied query isn't the one you want, but the question remains as to what SUM is desired when the user specifies multiple values. Also, as we have no sample data to work with, it's rather difficult to know how to write the code to meet your specific needs. We don't have DDL to describe each table involved, nor do we have any indication as to what a record in each such table represents, so we're seriously flying blind here. Please do what you can to fill the gaps....