X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Sum Once For Each Instance Of Account Number, XI    
post Jun 29 2016, 03:41 PM

Posts: 696
Joined: 5-November 07

On my crystal report, I have an account number, account holder name, the status, the date of the account, and the total commitment amount. Because an account number can have multiple status, I grouped the report by account number and then by account holder name. Everything was looking great until I tried to create a sum for each account holder of the commitment amount. It seems to be adding every instance of the account number for the multiple status together in the totals. How do I get it to add the commitment amount only once per account number? I unfortunately need status on the report.

Go to the top of the page
post Jul 1 2016, 10:49 AM

Posts: 919
Joined: 25-April 14

bring [status] into the query as groupby
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    6th August 2020 - 10:13 AM